View Single Post
  #1   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 -

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