excell 2002 round

[John]

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)

 

[Dave Peterson]

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)

 

[John]

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)

Thanks Dave,

Works perfectly.