HOTEL ACCOMODATIONS ROOMS DAYS ALLOWANCE TOTAL
1 2 $125.00 $200.00
This is what it is kickin out. The formula is as follows; =(C53*D53)*E53 Problem is D53 is calculated from another cell and comes up a decimal sometimes, but i have the number formating in the cell with no decimals to round up automatically. But the formula is still using the decimals? How do i make it use the displayed value, instead of the actual value? Thanks
Last edited by NBVC; 02-16-2012 at 04:20 PM.
=(C53*ROUND(D53,0))*E53
or if truly rounded up
=(C53*ROUNDUP(D53,0))*E53
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
What do you mean "truly rounded up" That might me need to know? Thanks
ROUND will round up or down based on the current number (i.e. above or below 5), ROUNDUP always rounds up to next higher value.
and to clarify D53 is the cell value that is rounded up.
You are the best! Thanks Man!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks