trying to add to a if statement

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
 
B

Bob Phillips

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

ob-server

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!C3>0)*(January!C3-January!E3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top