2 conditions for IF function?
Hi Paul
Is it as simple as this:
=IF(AO16<16,T10,"")
Thanks Steve - I have tried that already but it was returning
FALSE..... on further inspection this was because the linked cell also
contained a formula that was incomplete so was readign FALSE. A simple
use of conditional formatting to colour the text white if value = 0
has done the trick!
Thanks for your time
Best wishes
|