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?
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.