Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula percentage problem | New Users to Excel | |||
formula problem | New Users to Excel | |||
Problem with nested logical formula. | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Baffling formula problem | Excel Discussion (Misc queries) |