=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.

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.

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!

Ask Your Question

Weekly Poll