2 conditions for IF function?

[Porky79]

Hi -

I want to use a function to display a value in a cell if it meets 2
conditions

Condition 1) That there is data entered in cell T10 and if no data
return a blank in the cell
Condition 2) That the number in cell AO10 is <16

so I basically want to combine =IF(T10,T10,"") and =IF
(AO10<16,T10,""). I have tried AND but with no joy - sorry this is
baffling me!!

Thanks for your help

Paul

 

[Glenn]

Hi -

I want to use a function to display a value in a cell if it meets 2
conditions

Condition 1) That there is data entered in cell T10 and if no data
return a blank in the cell
Condition 2) That the number in cell AO10 is <16

so I basically want to combine =IF(T10,T10,"") and =IF
(AO10<16,T10,""). I have tried AND but with no joy - sorry this is
baffling me!!

Thanks for your help

Paul

=IF(AND(T10,AO10<16),T10,"")

 

[Scoops]

Hi -

I want to use a function to display a value in a cell if it meets 2
conditions

Condition 1) That there is data entered in cell T10 and if no data
return a blank in the cell
Condition 2) That the number in cell AO10 is <16

so I basically want to combine =IF(T10,T10,"") and =IF
(AO10<16,T10,""). I have tried AND but with no joy - sorry this is
baffling me!!

Thanks for your help

Paul

Hi Paul

Is it as simple as this:

=IF(AO16<16,T10,"")

?

Regards

Steve

 

[John]

Hi
Try this one : =IF(T10>0,IF(AO10>16,T10,""),"")
This will return blank if any of the two cells or both are blank .
HTH
John

 

[Porky79]

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