Thread: [Solved] Trying to round up a field based on a calculation but getting error messages
View Single Post
 
Old 10-09-2014, 10:14 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
You always want to round up, eh? That's very generous of you. ;-)

At any rate, regardless how you have a cell formatted, the underlying value remains the same.

Here's your formula:
=IF(M28>=1,((ROUNDUP(M28,0)-ROUNDUP(O28,0))*P28),"")
Reply With Quote