PDA

View Full Version : Solved: Multiple IF statement (??)



Hoopsah
02-14-2013, 03:38 AM
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
02-14-2013, 03:54 AM
Try

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

Hoopsah
02-14-2013, 04:08 AM
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
02-14-2013, 04:38 AM
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
02-14-2013, 04:50 AM
Is this what you mean Gerry?

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

Hoopsah
02-14-2013, 05:58 AM
Bob - Brilliant!

That is exactly what I needed.

Thanks again Bob

Gerry