Results 1 to 6 of 6

how do i get a function to multiply by rounded up number in the cell?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Texas
    MS-Off Ver
    Office 365
    Posts
    128

    how do i get a function to multiply by rounded up number in the cell?

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1