Help with if formula

[roxyr]

I'm in desperate need of some assistance.
Right now the formula in column G on the PDR tab reads that if th
gross margin is less than 4% then rate not approved, if more than 4
that the gross margin is "_". This was fine when everything had a 4
markup, but now some are 3% and some are 4%
I need the formula to work the same way but to take into consideratio
the following: in column G (on the PDR tab) to be modified so that i
column D is a 1 then the rule is 4%, and if it's a 2 then 3%.
Can someone PLEASE help me?!?

Many many thanks in advance

Attachment filename: sample.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=58326

 

[Frank Kabel]

Hi
could you post your existing formula?

 

[JulieD]

Hi

try

=IF(ISERROR((E12-F12)/E12),"",IF(D12=1,IF(ROUND((E12-F12)/E12,2)<0.04,"Rate
not approved",(E12-F12)/E12),IF(ROUND((E12-F12)/E12,2)<0.03,"Rate not
approved",(E12-F12)/E12)))

i also put some rounding in (you can take it out if you like)
let us know how you go.

Cheers
JulieD

 

[roxyr]

thank you soooooooooooooooo much...it works! You're a life saver and
appreciate your help

 

[JulieD]

Hi

glad it works.

Cheers
JulieD