trying to add to a if statement

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have this statement in B3;

=IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3)

I need to add;

if C3 >0 then B3 = C3

can this be done along with the first "if"

Thanks in advance...David D
 
=IF(January!C3>0,January!C3,IF(OR(January!B3 = 0,January!B3 =""),0,
January!B3-January!E3))
 
if
I need to add;

if C3 >0 then B3 = C3

can this be done along with the first "if"
Click to expand...

maybe

=IF(and(January!B3 = 0,January!C3 =0),0,(January!C3
=0)*(January!B3<>0)*(January!B3-January!E3)+(January!B3
=0)*(January!C3>0)*(January!C3-January!E3))
 
Back
Top