Hi
Try this one : =IF(T100,IF(AO1016,T10,""),"")
This will return blank if any of the two cells or both are blank .
HTH
John
"Porky79" wrote in message
...
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