update formula

From a syntax point of view you have an extra "and" in there, I think you want:

=IF(OR(T4>=0,S4>8%),"Update Quote",IF(AND(T4>0,T4<1000,S4<4%),"FVP Approval","RSVP Approval"))

Select allOpen in new window

But logically I'm not sure if that is what you truly want.  As it stands anytime T4<0 the first IF will be TRUE, so you will never get to the second IF...

---

»bp

Bill,
Yes, if T4 IS A NEGATIVE number then i should get an "Update Quote" .

Then maybe you want this?

=IF(OR(T4<0,S4>8%),"Update Quote",IF(AND(T4>=0,T4<1000,S4<4%),"FVP Approval","RSVP Approval"))

Select allOpen in new window

Which in sort of a verbal mode would be:

if T4 less than 0 or S4 greater than 8% then
      "UpdateQuote"
else
      if T4 greater than or equal to 0 and T4 less than 1000 and S4 less than 4% then
            "FVP Approval"
      else
            "RSVP Approval"
      end if
end if

---

»bp

I hope you can read this
D36EACC1-A219-45E2-AD78-1DA1B352A88.jpeg

T4. = $.       S.4. = %

Thanks Bill !

Bill, this is the formula that they want me to go with
=IF(OR(T4>=-250,S4>8%),"Update Quote",IF(AND(T4<-1000,S4<4%),"FVP Approval","RSVP or Director Approval"))

But, I have a request please.
They want to add a condition.
If Column P is <0 (or anything negative). they want that to be the first condition and exit formula..with text "FVP Approval"

I can repost a new question based on this if so ?

fordraiders

If I'm understanding, then wouldn't just be:

=IF(P4<0,"FVP Approval",IF(OR(T4>=-250,S4>8%),"Update Quote",IF(AND(T4<-1000,S4<4%),"FVP Approval","RSVP or Director Approval")))

Select allOpen in new window

---

»bp

thanks sir !!
 very much!