Rounding off Excel formula

[aacod]

Value in cell B4 is 22

Value in cell G7 is 267

I want a formula for 100-(B4/G7*100) ROUNDED OF TO NEAREST WHOLE FIGURE.

Actual value comes to 91.7603 which needs to be rounded off to 92


thanks in advance.

 

[VoG]

Try

=ROUND(100-(B4/G7*100),0)

 

[schielrn]

Not sure where you want it to be rounded before you subtract it from 100 or after the subtraction, but you can do something like:

=round(100-(B4/G7*100),0)

or:

=100-round(B4/G7*100,0)

Hope that helps.

 

[aacod]

Thanks,

Works.

 

[aacod]

When there are no figures in B4 and G7, it puts ?NAME, I want it to remain BLANK, when there are no values in the cells. Thanks.

 

[barry houdini]

You shouldn't get #NAME? error, I'd expect #DIV/0! but in any case try

=IF(COUNT(B4,G7)=2,ROUND(100-B4/G7*100,0),"")

 

[VoG]

Try

=IF(OR(B4="",G7=""),"",ROUND(100-(B4/G7*100),0))

 

[Scott Huish]

I would expect #DIV/0! also:

=IF(G7,ROUND(100-(B4/G7*100),0),"")

 

[aacod]

I tried all the formulas and they all work great.

Thanks everyone.