I desire to show TRUE/FALSE from a simple IF formula, example
=$E2<$P2 gives me TRUE and next $E3<P$3 also is TRUE, I want to show an empty cell until
it finds a FALSE
I attach a sample file. Kindly help.
Thank you.
I desire to show TRUE/FALSE from a simple IF formula, example
=$E2<$P2 gives me TRUE and next $E3<P$3 also is TRUE, I want to show an empty cell until
it finds a FALSE
I attach a sample file. Kindly help.
Thank you.
Try this formulaPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Hi Popipipo,
Your formula works..thank you so much. I convert data into Table and the same formula gives me #REF! error...can
you please modify formula so that it can work from the first row.
Thank you.
I attach the sample file for refecence.
Formula:Please Login or Register to view this content.
Thank you once again....but the first row should get a result of TRUE or FALSE
formula
=IF([@Column1]="","",IF(([@Column5]>[@Column15])=([@Column5]>[@Column15]),"",[Column5]>[Column15]))
gives me a blank cell, I desire
to get a TRUE or FALSE...and if TRUE then next should be FALSE then TRUE and so on....
Thank you
Try thisPlease Login or Register to view this content.
Hurraaay! this works...thank you soooo much!
Have a great week.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks