If this or that Formula

J

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
 
J

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
 
J

Jerry W. Lewis

JUAN said:
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
Click to expand...


You are welcome,
Jerry
 
Top