Hi everyone,
I'm new to excel and trying to write the following basic formula, can anyone help me?
If AF3 is greater than or equal to 5, and less than 6, then "1", otherwise "".
Thank you!
Hi everyone,
I'm new to excel and trying to write the following basic formula, can anyone help me?
If AF3 is greater than or equal to 5, and less than 6, then "1", otherwise "".
Thank you!
HI m_blanks,
Welcome to the forum.
Try using below formula:-
Formula:
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Thank you, I shall try it tomorrow and let you know how it goes!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks