PDA

View Full Version : Excel Formula



bk T
20-07-2005, 08:04 PM
=IF(D10="","",IF(E10="","",F9-E10+D10))


I created the above formula for F10 in my spreadsheet using Excel, which does not really work the way what I want it to be. It only works fine when both D10 and E10 are entered with a number; but when any of them (D10 or E10 is empty, nothing will be shown in say in F10.

This is what I want: if only BOTH D10 and E10 are empty, then nothing will be shown in F10.

How shall I do it?

Cheers

Big John
20-07-2005, 08:47 PM
=IF(D10="","",IF(E10="","",F9-E10+D10))


I created the above formula for F10 in my spreadsheet using Excel, which does not really work the way what I want it to be. It only works fine when both D10 and E10 are entered with a number; but when any of them (D10 or E10 is empty, nothing will be shown in say in F10.

This is what I want: if only BOTH D10 and E10 are empty, then nothing will be shown in F10.

How shall I do it?

Cheers

=IF(OR(D10="",E10=""),"",F9-E10+D10)

Should do it. Basically it says if D10 OR E10 = "" then put a blank otherwise put the formula.

B.M.
20-07-2005, 08:52 PM
Don't know if I've got the question right but is this what you want?

=IF(AND(D10="",E10=""),"",F9-E10+D10)

bk T
20-07-2005, 10:08 PM
Don't know if I've got the question right but is this what you want?

=IF(AND(D10="",E10=""),"",F9-E10+D10)

Thanks, B.M.

This is exactly what I wanted.