J
Jessica Walton
Hi Guys
I’m working with a formula in cell H361 to sum the cells H298:H360. (=SUM(IF(ISERROR(H298:H360),,(H298:H360))) is the formula...sorry, misposted before).
The majority of these cells contain zeros, but the formula in those respective cells is the following
=IF(G354<=0.5,0,IF(G354>=1.5,F355*0.5,F355*G356)). Because of this, some of the cells whose total is like .02 or .04 is causing my total cell to round to 4, when it should be 3 (all cells zeros + one cell 3 = 3). How can I get the total cell to equal 3? Do I need to reformat my zero cells or just the sum cell
Thanks in advance and have a great day
Jessic
I’m working with a formula in cell H361 to sum the cells H298:H360. (=SUM(IF(ISERROR(H298:H360),,(H298:H360))) is the formula...sorry, misposted before).
The majority of these cells contain zeros, but the formula in those respective cells is the following
=IF(G354<=0.5,0,IF(G354>=1.5,F355*0.5,F355*G356)). Because of this, some of the cells whose total is like .02 or .04 is causing my total cell to round to 4, when it should be 3 (all cells zeros + one cell 3 = 3). How can I get the total cell to equal 3? Do I need to reformat my zero cells or just the sum cell
Thanks in advance and have a great day
Jessic