trying to add to a if statement
 

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

trying to add to a if statement
 

=IF(C30,C3,IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3))
--
David Biddulph

"David" wrote in message
...
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

trying to add to a if statement
 

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


--
__________________________________
HTH

Bob

"David" wrote in message
...
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

trying to add to a if statement
 

if
I need to add;

if C3 0 then B3 = C3

can this be done along with the first "if"

maybe

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

"David" wrote:

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