Greetings,
Am frustrated and though I'd ask the Forum.
Effectively, I would like to view the value - for example - of Accounting cell b10 and, if value is <= 0 print FAIL in cell b11, otherwise, print PASS.
Can anyone help? Thanks
Mike
Greetings,
Am frustrated and though I'd ask the Forum.
Effectively, I would like to view the value - for example - of Accounting cell b10 and, if value is <= 0 print FAIL in cell b11, otherwise, print PASS.
Can anyone help? Thanks
Mike
In B11 type
= IF(B10 <=0,"FAIL","PASS")
Martin
Thank You Martin,
What would the syntax be if I wanted to print PASS in cell B13 (instead of B11)?
Mike
Same syntax - just put the formula in cell B13 instead.
Thanks again Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks