View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Porky79 Porky79 is offline
external usenet poster
 
Posts: 19
Default 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