Multiple IF functions

[blackshag]

Stuck on this a bit....
At any point in time cells B1, B2, B3, B4 will hold data. However, only one of those will hold data a single time.
I want A1 to show the result of the only cell with data (if no data is in any of the B cells, A1 should be blank)

Thank you!

[Ron Coderre]

Try this regular formula:

Please Login or Register  to view this content.

Is that what you're looking for?

[simarui]

how about:

Please Login or Register  to view this content.

?

[blackshag]

That is exactly it... Thank you.

One last thing, in doing so it is converting my fractions # ??/32 into decimals even though A1 is formatted as # ??/32 and so are all B cells. Any suggestions?

[Ron Coderre]

Are the contents of B1:B4 ALL fractions or can there be variety?
If they're all fractions AND there will only be one cell occupied then try this:
A1: =SUM(B1:B4)
or
A1: =VALUE(B1&B2&B3&B4)

Either formula results in a numeric value which will display in A1's number format.

Does that help?

[blackshag]

Used the =value formula.

Works perfectly now. Thanks for your help