Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multipying columns that contail null values
Hi,
I have two columns that I am trying to multiply (A and G). One has of the columns (F) is a calculated value that sometimes has null values. The formula for column G is =If(F2=0,"",E2/f2). So I get a null value if e2 is 0 or null. I now what to multiply column G by another column and place this in column H. However, when I do this, I get an #VALUE! as a value anytime the value in G in blank. I would like to supress this so that nothing appears in H if G is null. Can someone help me with this formula? Thanks, -- Chuck W |
#2
|
|||
|
|||
one way
=IF(iserror(g2*b2),"",g2*b2) assumes you waant to multiply g by b HTH "ChuckW" wrote: Hi, I have two columns that I am trying to multiply (A and G). One has of the columns (F) is a calculated value that sometimes has null values. The formula for column G is =If(F2=0,"",E2/f2). So I get a null value if e2 is 0 or null. I now what to multiply column G by another column and place this in column H. However, when I do this, I get an #VALUE! as a value anytime the value in G in blank. I would like to supress this so that nothing appears in H if G is null. Can someone help me with this formula? Thanks, -- Chuck W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Line graphs with null values | Charts and Charting in Excel | |||
How do I get unique values from 2 columns? | Excel Discussion (Misc queries) | |||
Creating a chart with values from two columns | Charts and Charting in Excel |