Help with IF statements and calculated parameters

[bmyrumYGWJ2]

I am trying to get a door to show two values depending on the occupant load (Count). I have an equation that gets me the required door width but since the minimum is 32" I need to say 32 unless it is larger.

If the occupant load Required Width requires less than 32" I want it to say 32.

If the occupant load Required Width requires more than 32" I want it to say the value 

(Count * Factor) is the calculation for our Required Width

If ((Count * Factor) < 32 , 32 , IF (Count * Factor) > 32, (Count * Factor))

I don't know if I am doing too much in one equation or just not getting my statement correct. I have made this work with windows before but it has been awhile.

Does this make sense?

[barthbradley · Accepted solution]

You're not doing too much.  Embedding IF statements is pretty common.  What error is being thrown?  

Why the embedded If Statement? Wouldn't "If ((Count * Factor) < 32 , 32 , (Count * Factor))" yeild the same result? 

Ah, I see.  You need an additonal result at end.  If true: do this. If not true: do this.

If ((Count * Factor) < 32 , 32 , IF (Count * Factor) > 32, (Count * Factor), DO THIS))

[ToanDN · Accepted solution]

if((Count * Factor) < 32, 32, (Count * Factor))