If this or that Formula

[JUAN]

Hello,
need help with a formula. Lets said I have three columns
that contain price:

L M N
..02 .026 empty

I want to do if L has price use that price. If is empty,
and N has price, then use N price. If L and N are empty,
then use M price. If L,M,N empty then show EMPTY.
So basically. COlumn L is first, N is second and M is
third.
I'm not too familiar with a comlex If statement.

Hope I make sense, Any help would really be very
appreciated.
Thanks,
Juan

 

[Jerry W. Lewis]

=IF(ISNUMBER(L1),L1,IF(ISNUMBER(M1),M1,IF(ISNUMBER(N1),N1,"")))

Jerry

 

[JUAN]

Hello Jerry,
thanks so much for your help. Your formula seems to easy.
I have been trying to figure it out and I was able to get
to the second level but havent' been able to get the last
If.
I did a quick test using your formula and seems to
work. Once again thanks so much for your help.
Juan

 

[Jerry W. Lewis]

Hello Jerry,
thanks so much for your help. Your formula seems to easy.
I have been trying to figure it out and I was able to get
to the second level but havent' been able to get the last
If.
I did a quick test using your formula and seems to
work. Once again thanks so much for your help.
Juan

You are welcome,
Jerry