I think you need the formula
=IF(A1<20,0,IF(A120,B1*24,FALSE))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"AKlein" wrote in message
...
I'm trying to use the IF function to return either a 0 or the
result of a
forumla. See example below.
col. A Col. B col. c (Formula)
col. C result
8 $18 =IF (A1<20,"0", A120,"result of B1*24")
0
22 $84 =IF (A2<20,"0", A220,"result of B2*24")
$2,016
How can I write the formula so that result in Col C. is can
return the
result of a formula?