View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mukesh Mukesh is offline
external usenet poster
 
Posts: 78
Default =IF(AND... function

I need 2 conditions to meet else it should be an empty sell.
My code is
=IF(AND(K47="abc", B3=I49), (H49-B3)*J49*1000, (H49-I49)*J49*1000)

I still get the calculated value, even if cell K47 is blank.

Please help.

Thanks.
Mukesh