Help with if formula

R

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
 
J

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
 
R

roxyr

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top