IF Function

[ellpis]

I would like to develop a value in cell G4 of sheet B in a multi-sheet workbook that is the result of the following;
If E4=0, than D4+F4, If F4=0, than D4+E4. F4 will always be
0 if E4 has a value, and visa-versa.
Thanks,
Dave

 

[DaleWatson123321]

Hi Dave,

This should work...

@IF(E4=0,D4+F4,IF(F4=0,D4+E4,"ERROR&quot)

Please advise as to how it "fits".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[ellpis]

Thank you for your help. The formula that worked in this situation was simply @SUM(D4)+(E4+F4) since either e4 or f4 would be 0 in each case.