formula within IF function

[Guest]

How do I use a formula within the IF function? What I want to do is check if
a number is less than or equal to an amount, calculate one thing, if it is
not, calculate another. I tried this: IF(B21<=150,"=B21*E32","150*E32)
But I only get text returned.

Please help!!
Thanks

 

[Domenic]

Try...

=IF(B21<=150,B21*E32,150*E32)

Hope this helps!

 

[Guest]

Try

=IF(B21<=150,B21*E32,150*E32)

I assume that B21, and E22 are numeric.

 

[\VoG via OfficeKB.com\]

Remove the " marks from your formula.

 

[Dana DeLouis]

Maybe a slight variation:

=E32*MIN(B21,150)

HTH.

 

[Guest]

Thx to all ur posts-they are very*3 useful!!!!!!!