Another Excel Question

[Jason Betts]

Hi guys, I have a formula in a cell =(F2-G2) and I want to tell the cell to round to the nearest hundredth. I Googled it but the formula examples I saw had multiple cells, say one cell giving the raw output and a second cell rounding that other cell's output, I just want one cell to preform my formula then round the answer. How do I do that? 

 

Thanks, Jason.

[manikyath]

off the top of my head, you can just give that cell a custom markup to only display to the nearest hundredth.

[Aleksbgbg]

12 minutes ago, Jason Betts said:

Hi guys, I have a formula in a cell =(F2-G2) and I want to tell the cell to round to the nearest hundredth. I Googled it but the formula examples I saw had multiple cells, say one cell giving the raw output and a second cell rounding that other cell's output, I just want one cell to preform my formula then round the answer. How do I do that? 

 

Thanks, Jason.

Format as number, then decrease decimal point?

[Canada EH]

Top in the ribbon

[vinx]

20 minutes ago, Jason Betts said:

Hi guys, I have a formula in a cell =(F2-G2) and I want to tell the cell to round to the nearest hundredth. I Googled it but the formula examples I saw had multiple cells, say one cell giving the raw output and a second cell rounding that other cell's output, I just want one cell to preform my formula then round the answer. How do I do that? 

 

Thanks, Jason.

use ROUNDDOWN,

=ROUNDDOWN(F2-G2,0)

 

on the cell you want to display the result. simply use =ROUNDDOWN(F2-G2,0)

the use of "0" will round down the number to the nearest whole number.

[Jason Betts]

12 minutes ago, manikyath said:

off the top of my head, you can just give that cell a custom markup to only display to the nearest hundredth.

Cool, but how do I do that? 

[Jason Betts]

1 minute ago, vinx said:

use ROUNDDOWN,

=ROUNDDOWN(F2-G2,0)

 

 

That's perfect! Now that I understand the syntax I have made two changes:

=ROUNDUP(F2-G2,2)

 

0 to 2, because I want hundredths

Round up, because this is for my taxes, I'd rather say it cost me a few pennies more than less.

 

Thank you!  

[manikyath]

1 minute ago, Jason Betts said:

That's perfect! Now that I understand the syntax I have made two changes:

=ROUNDUP(F2-G2,2)

 

0 to 2, because I want hundredths

Round up, because this is for my taxes, I'd rather say it cost me a few pennies more than less.

 

Thank you!  

is there an =ROUND function? (i dont have excel on hand right now

[vinx]

1 minute ago, Jason Betts said:

That's perfect! Now that I understand the syntax I have made two changes:

=ROUNDUP(F2-G2,2)

 

0 to 2, because I want hundredths

Round up, because this is for my taxes, I'd rather say it cost me a few pennies more than less.

 

Thank you!  

That's great.