Combine Multiple Working IF Formulas in One Cell

[conwaythibodeaux]

I am working on a spread sheet to calculate price per foot per item type. In the attached example sheet, I have 3 working formulas in the green cells (L4, M4 and N4). I am wanting/needing all three combined as one formula in L4.

If cells D, E, and F will have all "0" or left blank, cell L4 is to remain blank.

For the calculation a number grater than "0" will be entered into either cell D, E, or F to give the total. The sample sheet is shown with 10 entered in cells D,E, and F for demonstration purposes only.

[brant.wheeler]

The formula you need in cell L4 is below. Note that when you add blank cells together, the result is 0. The "if" statement condition uses this principle.

=IF(D4+E4+F4=0,"",C4*((D4*I4+G4)+(E4*J4+H4)+(F4*K4+H4)))

[conwaythibodeaux]

Thank you brant.wheeler,
However it didn't work as needed.
Here I used your suggestion and it gave me 100 assuming 10 in all C,D, and E.
Sample for IF screenshot1.PNG

In cell D, I used 10 and the answer is 20 as shown in L4, but the formula outputs 50 instead of 20.
Sample for IF screenshot2.PNG

In cell E, I used 10 and the answer is 35 as shown in M4, but the formula outputs 60 instead of 35.
Sample for IF screenshot3.PNG

In cell F, I used 10 and the answer is 45 as shown in N4, but the formula outputs 70 instead of 45.
Sample for IF screenshot4.PNG

[jtakw]

Hi,

Use this in L4:

Please Login or Register  to view this content.

[FlameRetired]

If I understand correctly this in L4 and filled across.

Please Login or Register  to view this content.

[conwaythibodeaux]

Thank you jtakw,
This one seems to be working as needed.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[jtakw]

You're welcome, thanks for the feedback and rep.