Forum Home
Press F1
Thread ID: 60028	2005-07-20 08:04:00	Excel Formula	bk T (215)	Press F1

Post ID	Timestamp	Content	User
373891	2005-07-20 08:04:00	=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	bk T (215)
373892	2005-07-20 08:47:00	=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.	Big John (551)
373893	2005-07-20 08:52:00	Don't know if I've got the question right but is this what you want? =IF(AND(D10="",E10=""),"",F9-E10+D10)	B.M. (505)
373894	2005-07-20 10:08:00	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 .	bk T (215)
1