Microsoft Office Forums - View Single Post - [Solved] ** Excel Formula

Thread: [Solved] ** Excel Formula

View Single Post

Old

03-23-2011, 06:02 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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)

Reply With Quote