The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

(Solved) - Excel ROUNDUP to controlled number

(4 posts)
  • Started 3 years ago by les
  • Latest reply from moreeg
  • Topic Viewed 782 times


Recommended: Clean Your PC the Easy Way with CleanMyPC

If you want to clean up your PC the easy way, CleanMyPC is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyPC for Free Today

Posted yesterday 
Posts: 18

Here is what I am trying to do.
Windows XP Microsoft Office Excel 2010
I have an entry cell B6 and a data cell C6. In cell A7 I have the formula =ROUNDUP(B6/C6,0)
What I want to do is if the value in cell B6 is less than 200 it will roundup the value in A7, but if the value in B6 is greater than 200 it will not round up. Is this possible?

Second question.
About 4 months ago I posted a question on how to change the font color in Excel 2003 when a certain condition was met in an entry cell. Moreeg sent me a response that worked great. Conditional Formatting. Since then I have upgraded to Excel 2010 and now it does not work right. I have to exit out of the page to make it work. If I exit and go back to the page it will have changed but as long as I am on the page it does not change.

If you get this Moreeg Hello from Colorado USA. Hope all is well with you.

Posted 3 years ago
Posts: 842

Hey Les
Nice to see you back.

1. Try this formula


2. Conditional formatting was vastly changed and improved in 2007/2010 so I think the only option is to rebuild the conditional formats.

Click on A7
Click on conditional format and Clear rules to get rid of the 2003 stuff
Click conditional format again and New Rule
In the screen that appears select "Use a formula to determine...."
and then its the same as before ... enter =A7<>"" in the "Format values where this is true" box and then click on format to get your font colour. "ok" your way out and you should be good to go

Accepted Answer · Posted 3 years ago
Posts: 18

Thanks Moreeg, they worked great as usual.
I like your little dancing icon.


Posted 3 years ago
Posts: 842

You're welcome Les. Always happy to help.

As to the dancing men you'd have to be a real film nut to recognise the dancing men as Laurel and Hardy. I still remember watching Babes in Toyland when I was a child and being enthralled at the idea of toys coming to "life". Perhaps foreseeing the possibility of robotics ? .... and my interest in technology???

Posted 3 years ago

Topic Closed

This topic has been closed to new replies.