IF Function returns result of formula

[Guest]

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", A1>20,"result of B1*24")
0
22 $84 =IF (A2<20,"0", A2>20,"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?

 

[Niek Otten]

=IF(A1<20,0,B1*24)

Copy down

 

[Chip Pearson]

I think you need the formula

=IF(A1<20,0,IF(A1>20,B1*24,FALSE))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com