Return value, if blank then return value of another cell

[mlu120]

Hi,

I want a formula that will return with the value of cell A1 but if cell A1 is blank, then it will take only the value of C1.

I tried using this formula - not working right.

Thanks

 

[Bob1981]

Hi, I need some help with a formula.

I have a £ in cell d7 & want that to populate into cell f7 as a default. But if there's a value in f14 I want that to then take over & be the default for cell f7. So if f14 is blank or 0 I want it to pull d7 but if not return f14 into f7....

If you can help that'd be great!

 

[donny_benjamin]

Hi All,
This is very helpful. I'd like to add to the first question. What if c1 is also blank and I want the value of D1? Would this be a nested if statement? If so, how would you write it?

 

[jtakw]

Hi,

It'll be:

=IF(A1="",IF(C1="",D1,C1),A1)

 

[donny_benjamin]

Hi,

It'll be:

=IF(A1="",IF(C1="",D1,C1),A1)

Hi Jtakw,
Thanks a million for your help. This works perfectly. I tried so many variations but couldn't get it right. Truly appreciate the help.

 

[jtakw]

You're welcome, thanks for the feedback.

 

[CaseyJones1979]

Hi,

It'll be:

=IF(A1="",IF(C1="",D1,C1),A1)

Hi @jtakw

I need something very similar to this, but am having trouble re-conjugating the above formula to suit my needs. Are you still hanging around and available to help?

Here's is basically what I am trying to accomplish, though a simplified version, as my cells are not adjacent.

= D
If D = 0, then = C
If C = 0, then = B
If B = 0, then = A

Thank you