Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |