Solved: If statment with 3 arguments?

[Barryj]

I am trying to come up with a formula with 3 arguments, in the attached file I need the cell in A5 to always show the number in the top cell of C6 to C4.

Example if the number is in cell C6 then show that, If the number is in cell C5 then show that, If the number is in cell C6 then show that.

I have worked on a formula that will show 2 of the numbers but can not get it to work for the 3 cells.

=IF(C5="",C6,C5) this formula is in cell A5.

Thanks for any help.

[moa]

you will need to use an if statement within your if statement:
=IF(C4 ="",IF( C5 ="",C6,C5),C4)

[Barryj]

Thankyou very much MOA, works great.