Excel if/and
You're welcome.
But are you KarenB also?
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"jerminski73" wrote in message
...
Thanks for solving my problem with this solution!!!
Jeremy
"Ragdyer" wrote:
Try this:
=LOOKUP(B2,{0,35,40,45,50;250,500,750,1000,1250})
|