Thread
:
=IF(AND... function
View Single Post
#
1
Posted to microsoft.public.excel.misc
Mukesh
external usenet poster
Posts: 78
=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
Reply With Quote
Mukesh
View Public Profile
Find all posts by Mukesh