ROUND function syntax question (hopefully simple)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Xylas - 01 Nov 2007 15:45 GMT

I want to round the results of the following formula to a single
decimal place. Can anyone tell me the correct syntax to use the ROUND
function? Putting all the commas and parentheses in the right place
has always been my downfall where long, complicated Excel functions
are concerned!

The formula is: =IF(J7>0,D7/J7*100,"")

Reply to this Message

JE McGimpsey - 01 Nov 2007 15:48 GMT

One way:

=IF(J7>0,ROUND(D7/J7*100,1),"")

> I want to round the results of the following formula to a single
> decimal place. Can anyone tell me the correct syntax to use the ROUND
[quoted text clipped - 3 lines]
>
> The formula is: =IF(J7>0,D7/J7*100,"")

Reply to this Message

Nick Xylas - 01 Nov 2007 16:18 GMT

> One way:
>
> =IF(J7>0,ROUND(D7/J7*100,1),"")

Thanks

Reply to this Message