Check this out

http://www.rondebruin.nl/easyfilter.htm

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"LeslieO via OfficeKB.com" wrote:

Hi, I'm stuck on a formula I'm trying to add to my spreadsheet. Essentially,
I need the formula to do the following:
In the formula cell (D1),
If A1 is 0, then I need the answer to be :
$40.00 if B1 says X
$30.00 if B1 says Y
$30.00 if B1 says Z

and so on.

I tried the following and it's not working because I can't figure out how to
get the formula to check A1 for a value before it runs the IF test. I've
edited the last bit of the formula (etc.). I have additional if tests, not
etc. What do I need to add to this or should I scrap it and try a straight
Lookup? All help is greatly appreciated!

=IF(B1="X",40,IF(B1="Y",30,IF(B1="Z",etc.)))))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1