J John Dec 18, 2008 #1 I am trying to get the result from this formula to round, =IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I)
I am trying to get the result from this formula to round, =IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I)
D Dave Peterson Dec 18, 2008 #2 Maybe... =round(IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I),2) (change that last 2 to what you want.) personally, I find this syntax difficult to read. If the formula were on row 1, I'd use: =round(IF(Q1<=5000,Q1*0.06+Q1*I1,Q1*0.06+5000*I1),2)
Maybe... =round(IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I),2) (change that last 2 to what you want.) personally, I find this syntax difficult to read. If the formula were on row 1, I'd use: =round(IF(Q1<=5000,Q1*0.06+Q1*I1,Q1*0.06+5000*I1),2)
J John Dec 18, 2008 #3 Dave Peterson said: Maybe... =round(IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I),2) (change that last 2 to what you want.) personally, I find this syntax difficult to read. If the formula were on row 1, I'd use: =round(IF(Q1<=5000,Q1*0.06+Q1*I1,Q1*0.06+5000*I1),2) Click to expand... Thanks Dave, Works perfectly.
Dave Peterson said: Maybe... =round(IF(Q:Q<=5000,Q:Q*0.06+Q:Q*I:I,Q:Q*0.06+5000*I:I),2) (change that last 2 to what you want.) personally, I find this syntax difficult to read. If the formula were on row 1, I'd use: =round(IF(Q1<=5000,Q1*0.06+Q1*I1,Q1*0.06+5000*I1),2) Click to expand... Thanks Dave, Works perfectly.
