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

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

Copy down

--
Kind regards,

Niek Otten

"AKlein" <[email protected]> wrote in message
news:[email protected]...
> 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?

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


"AKlein" <[email protected]> wrote in message
news:[email protected]...
> 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?