Hi guys,
How do you use two criteria in an IF function?
I need to use:
IF(E540<1 and B540>1,
Hi guys,
How do you use two criteria in an IF function?
I need to use:
IF(E540<1 and B540>1,
=IF(AND(E540<1,B540>1),Action true, Action if false)
Elegant Simplicity............. Not Always
Try like this...
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks - elegant and simple
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks