Solved Nested IF(AND/OR) Formula & how to arrange the conditions

June 21, 2016 at 10:31:51
Specs: Windows 64
=IF(OR(O4>=1,O4*30>=100),O4*30)

I need this formula to state IF O4 is greater than or equal to 1, then 04 * 30. IF O4 is blank then leave blank (AND/OR) not sure which one.... IF the answer to O4*30 is 100 or more then default to 100.

Please help.


See More: Nested IF(AND/OR) Formula & how to arrange the conditions

Report •


#1
June 21, 2016 at 11:26:12
✔ Best Answer
Try the following formula.

When using Nested IF's, you have to ensure that one clause doesn't override all the others. In this case, if the O4>=1 clause was before O4*30>=100, the answer would always be O4*30 because O4*30 will always be greater than 1 for any whole number

=IF(O4="","",IF(O4*30>=100,100,IF(O4>=1,O4*30)))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 21, 2016 at 11:38:02
OMG, it worked, it actually worked!! Thank you 1 million times over! I have two more ?'s to post then I think I'll be all-set. I'll post them separately. Hopefully, my ?'s will help others.

Seriously, you have saved my hide!

I appreciate it!


Report •
Related Solutions


Ask Question