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

I feel lame. Didn't take much to fix this. Just in case someone else is
looking for this kind of information the formula is below:

=IF(A1=0,0,IF(B1="X",40,IF(B1="Y",30,IF(B1="Z",30, IF(B1="etc",3,IF(B1="etc",
40,""))))))

This formula will check one cell (A1) for a value more than 0, then goes to
another cell to check for particular values (X,Y,Z) and returns the
appropriate value. This reminds me of a LOOKUP function. There's probably a
more elegant solution that I'm not thinking of.

LeslieO 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 http://www.officekb.com

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

and so on.

How many "and so on's" are there?

$40.00 if B1 says X
$30.00 if B1 says Y
$30.00 if B1 says Z

Are the repeat 30's correct?

=IF(A10,IF(B1="X",40,IF(OR(B1="Y",B1="Z"),30,"")) ,"")

Biff

"LeslieO via OfficeKB.com" <u30884@uwe wrote in message
news:6c59a0c4dd900@uwe...
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

=IF(AND(ISNUMBER(A1),A10),IF(B1="X",40,IF(OR(B1={ "Y","Z"}),30)),0)


"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