# Use Cell Value, If Below Value, For Calculations. Otherwise Used Fixed Value

• Good morning again,

Boss needs me to formulate a worksheet and I dont quite know how to tell it what it needs to do. Let me see if I can explain. The MS State Tax Credit maximum is \$500 per person. I need my worksheet to give me a total of his and hers credit taken but it cannot exceed \$500 each. The formula is nested inside another formula so that might make it change the way it's written a little bit.
Ex:
(D21*12)*F23+(E21*12)*G23 with the paranthesized (is that even a word?) sections being what I need to cap at \$500. Can anyone help me with this please?

• Re: Total Not To Exceed

something like?:

=(IF(D21*12>500,500,D21*12))*F23+(IF(E21*12>500,500,E21*12))*G23

• Re: Total Not To Exceed

Or [COLOR="Blue"]MIN(500, D21*12) * F23 + MIN(500, E21*12) * G23 [/COLOR]

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Total Not To Exceed

Quote from Sicarii

something like?:

=(IF(D21*12>500,500,D21*12))*F23+(IF(E21*12>500,500,E21*12))*G23

Absolutely perfect! Thank you so much, the boss is happy. :wowee:

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!