IF Function returns result of formula
 

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?

IF Function returns result of formula
 

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

Copy down

--
Kind regards,

Niek Otten

"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?

IF Function returns result of formula
 

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?