** Excel Formula

		Microsoft Office Forums > Microsoft Excel > Excel
** Excel Formula

FAQ

Thread Tools

Display Modes

03-23-2011, 06:02 PM

Colin Legg Colin Legg is offline

Windows 7 32bit ** Excel Formula

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Hi Rey,

Thanks, that explains it well. You don't say what should be returned if neither number is a whole number, so I will assume that at least one of them always will be.

Code:

=IF(TRUNC(A1)=A1,IF(TRUNC(B1)=B1,MIN(A1,B1),A1),B1)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to solve this formula in excel	BrOkEn_iCe	Excel	2	12-21-2010 05:45 AM
excel help Formula	sellspeed	Excel	15	03-10-2010 10:57 AM
Needs help to find excel formula- Please	aamer_1983	Excel	2	07-13-2009 01:46 AM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM
Excel Formula Help	Shahzad	Excel	1	12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:39 PM.