IF statements

[zmbaker]

I am trying to create an IF statement to do the following.

Apply a formula to cell A1 if cell A1 is blank apply a formula to cell B1 if cell B1 is blank apply formula to cell C1.

Can anyone help me with this

[Sam Capricci]

You want a formula IN cell A1 that says if this cell (A1) is blank do something - is that correct? OR are you saying that you want to have a value in A1 but if there is no value in A1 then apply this formula to A1?

[etaf]

can you expand a little

what formula do you want to apply - and where do you want the result of the IF statement

=IF( A1="", formula using B1, IF( B1="", formula using C1, formula to use if A1 and B1 blank))

[FDibbins]

hi and welcome to the forum

You will have to supply more detail to your requirements. formulas cannot "apply" a formula to another cell, a formula in a cell responds to data fed to it from other cells.

What exactly are you trying to do?

[zmbaker]

A1 B1 C1 D1
Profit Margin Day A Profit Margin Day B Profit Margin Day C Total
Item 1 27 22 18 X
Item 2 37 33 X
Item 3 15 X

I am looking for a formula to apply to column D that uses a weighted average but uses IF statements to that if a value is left out in one of the days then it skips over and uses the next days value.

[zmbaker]

Does any have a solution to this yet?

[Sam Capricci]

One problem might be that trying to work from a jpg isn't helpful. Your screen shot does not show any of the cells you mention in your post (A, B, C etc.). For more help it would be good for you to upload a sample spreadsheet with what you have and the results you expect.

[ben_hensel]

Does any have a solution to this yet?

If what etaf gave didn't already answer your question, then I don't understand what you're looking for.