Solved: Multiple IF statement (??)

[Hoopsah]

Hi

I have a spreadsheet where I want the contents of cell D6 to show the figure in cell D5, HOWEVER, if D5 = 0 then contents of cell D4 and if D4 is = 0 then celll D3.

Any help appreciated,

Cheers

[Bob Phillips]

Try

=IF(D5<>0,D5,IF(D4<>0,D4,D3))

[Hoopsah]

Fantastic Bob,

Thanks for your help - I get myself bogged down at times trying to find a complex way of doing things, you as usual make it look so simple,

Thanks again

Gerry

[Hoopsah]

Sorry about this Bob,

Knew it couldn't be that easy.

In cell D5 the user has a formula that links to another cell with a formula.

This means that your formula is now showing d4 instead of 0 (???)

Is there a way to do what you did except put a zero if the formula is returning no value??

[Bob Phillips]

Is this what you mean Gerry?

=IF(LEN(D5)>0,D5,IF(LEN(D4)>0,D4,D3))

[Hoopsah]

Bob - Brilliant!

That is exactly what I needed.

Thanks again Bob

Gerry