Question on this formula

[daaron1983]

What is it a about this formula on why t wont work? What ()"s missing? Any help will be appreciated.


=IF($G$20=$S$22,(B32-(B32*0.3%+1.5,(IF(AND($G$20=$S$23),(B32-((B32*0.15%+0.3)

 

[StephenCrump]

Welcome to the Forum!

First guess (I don't know whether you actually need the AND?):

=IF($G$20=$S$22,0.997*B32-1.5,IF($G$20=$S$23,0.9985*B32-0.3,"What else?"))

where "What else?" is the value you want if G20 is not equal to S22 or S23?

 

[Logit]

.
Or is this what you were seeking :

=IF(G20=S22,(B32-(B32*0.3%+1.5)),IF(G20=S23,B32-(B32*0.15%+0.3),""))