Thread: [Solved] ** Excel Formula
View Single Post
 
Old 03-23-2011, 06:02 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 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)
__________________
Colin

RAD Excel Blog
Reply With Quote