Trying to round up a field based on a calculation but getting error messages

		Microsoft Office Forums > Microsoft Excel > Excel
Trying to round up a field based on a calculation but getting error messages

10-09-2014, 11:49 AM

gebobs

Windows 7 64bit Trying to round up a field based on a calculation but getting error messages

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

In fact, get rid of the if >=1. You don't need it.

=((ROUNDUP(M28,0)-ROUNDUP(O28,0))*P28)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating new field in pivot table based off existing field	laceymarie1987	Excel	0	06-26-2014 12:13 PM
Form field calculation returning 2x correct result	Jschueller	Word	1	08-20-2013 01:51 PM
Rules based due date calculation	dlowrey	Excel Programming	3	05-12-2013 08:30 PM
Prevent Field Calculation with Dates from introducing line break?	ztag	Word	1	01-13-2012 04:13 PM
Mail Merge Calculation Error	Lsbutler2000	Mail Merge	1	06-22-2007 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:38 PM.