Formula help

[bankerlady]

I need help with a formula.
I have four columns, A, B, C, D with column headings Threshold, Target, Stretch, Actual.

I have dollar amounts amounts (goals) in threshold, target and stretch and an actual production number in the actual column.

In column E I want it to display a value as follows:

if d3=>a3,10 **this part I can get to work fine, I just am not getting parenthesis or punctuation right from here on !!

or if D3=>b3,40; or if D3=:c3,75, otherwise just give me a zero.

How do I structure this formula to return the results I need.

Thanks in advance for any help...this board is great !!!

 

[swst]

Here is a formula. Hope it helps

=IF(D3>=C3,75,IF(D3>=B3,40,IF(D3<B3,10,0))

Steve

 

[swst]

Last bit of formula missing .
Add this to end

<B3,10,0)))

Sorry about that

Steve

 

[swst]

Didn't paste here is last bit of formula


<B3,10,0)))

Steve

 

[Joe4]

Duplicate:
http://www.mrexcel.com/board2/viewtopic.php?t=284212&highlight=