Hello,
Looking for a if then formula please.
IF A1=1 then B1+C1 but if A1=0 then B1+D1, but if A1=Blank then dont sum anything?
RR
Hello,
Looking for a if then formula please.
IF A1=1 then B1+C1 but if A1=0 then B1+D1, but if A1=Blank then dont sum anything?
RR
Try this...
=IF(A1="","",IF(A1=1,B1+C1,IF(A1=0,B1+D1,"")))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
=if(a1="","",if(a1=0,b1+d1,if(a1=1,b1+c1,"")))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks