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

FAQ

Thread Tools

Display Modes

10-13-2014, 08:42 AM

bakerrl

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

Mac OS X

Office for Mac 2011

Novice

Join Date: Sep 2014

Posts: 13

Sample attached

Here's the sample sheet attached with the "value" error in it. It works fine, but the value doesn't disappear until you put a number in for the milage and tab over. Thanks for the help!

Attached Files

CO-A-00016 Travel Expense Form 10_13_14.xlsx (82.2 KB, 10 views)

« Previous Thread | Next Thread »

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 03:18 AM.