# Problem figuring formula

1. ## Problem figuring formula

Help. I want cell C20 to populate a formula that is

If cell h20 is \$0
then put cell G20 there

I thought it was something like =sum(IF

2. ## Re: Problem figuring formula

=IF(H20=0,G20,"")
or
=IF(H20=0,G20,"it ain't zero")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MarthaMartha" <[email protected]> wrote in message
news:[email protected]...
> Help. I want cell C20 to populate a formula that is
>
> If cell h20 is \$0
> then put cell G20 there
>
> I thought it was something like =sum(IF

3. ## Re: Problem figuring formula

You can also use something like
=(H20=0)*G20

This will put G20 when h20=0 and zero otherwise

George

MarthaMartha wrote:
> Help. I want cell C20 to populate a formula that is
>
> If cell h20 is \$0
> then put cell G20 there
>
> I thought it was something like =sum(IF

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1