If Statement Again.

[Mel B]

Simple but I'm not seeing it.

I'm talking about an 80 site campground, Sites 1-26 do not have electricity, sites 27 - 43 have electricity, sites 44 - 81 do not have elctricity. I need a formula that will give a $0.00 answer for non-electric and a $5.00 answer for electric sites. Thanks again, you guidance in the past has been great. I love the dropdown box answer and have incorporated it into my project.

Mel B

[martindwilson]

=LOOKUP(A1,{1,27,44},{0,5,0}) where a1=site number

[Mel B]

WWWWOOOOOOOOOWWWWWWWWWWWWWWWW!, I totally missed the lookup function. It worked great. Thanks very much. I'll be back.

Mel