Hello Miloud,
You can you following formula for the same.
=IF(A1<=9,1,IF(A1<=999,2,IF(A1<=1000,3,0)))
regards
Hello Miloud,
You can you following formula for the same.
=IF(A1<=9,1,IF(A1<=999,2,IF(A1<=1000,3,0)))
regards
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks