Problem with formula!

		Microsoft Office Forums > Microsoft Excel > Excel
Problem with formula!

FAQ

Thread Tools

Display Modes

02-04-2014, 01:10 PM

Pecoflyer

Windows 7 64bit Problem with formula!

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Does the following help? (B1 contains the number of widths) =IF(MOD(B1,1)>0.1,CEILING(B1,1),FLOOR(B1,1))

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

2003 to 2007 excel, formula, rounding

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup formula Problem (salary plus (commission x sales))	topgear2015	Excel	11	06-05-2013 09:02 PM
Formula Help	OTPM	Excel	2	05-22-2013 06:28 AM
Embedded IF AND OR Formula Problem	J Morrow	Excel	9	08-26-2011 06:51 AM
Formula problem?	markg2	Excel	11	06-10-2010 07:42 AM
Need help with a formula	tinkertron	Excel	11	04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:52 AM.