Two conditions, one formula?

[bpflyr]

I know I'm close to a formula, but I just keep getting stuck. Here's what I'm trying to do in one formula:

IF J138 is blank (no data), then return E138
IF LEN(J138)>0, then return SUM(E138-J138)
Otherwise be blank.

Thank you!

 

[Norie]

Try this

=IF(LEN(J138)>0, E138-J138, E138)

 

[bpflyr]

Thank you, that works, but I need to add...(this formula is going into cell K138)

IF the formula does do the calculation E138-J138, then K138, needs to be blank, otherwise, like you wrote, return E138.

Thanks.

 

[Yogi Anand]

Hi bpflyer:

Try ...

=IF(LEN(J138),E138-J138,"")