Hello out there, I need help in creating an IF formula that will allow me to tie new custom field called "Forecast Category Rating" to the Probability stage. Our probability stages are 25%, 50%, 75% and 90%. I'd like the Forecast Category Rating to correspond to the Probability percentages e.g. if probability >= 25% the Forecast Category Rating = D (C for 50%, B for 75% and A for 90%).

I tried this formula and get a syntax error missing ')'..Any ideas? Thanks in advance to all. My email address is dennis.dipietro@acsacs.com.

IF (Probability  >= 25, "D", IF (Probability  >= 50, "C", IF (Probability  >= 75, "B", IF (Probability >= 90, "A"))


Message Edited by Slide6 on 07-28-2008 02:27 PM