Maybe a slight variation:

=E32*MIN(B21,150)

HTH.
--
Dana DeLouis
Win XP & Office 2003


"Shirley" wrote in message
...
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
--
Shirley