formula within IF function
 

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

Try...

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

Hope this helps!

In article ,
"Shirley" wrote:

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

Try

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

I assume that B21, and E22 are numeric.

"Shirley" wrote:

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

Remove the " marks from your formula.

--
Message posted via http://www.officekb.com

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

formula within IF function
 

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