Microsoft Office Forums - View Single Post - Help with IF or ELSE Formulas

Thread: Help with IF or ELSE Formulas

View Single Post

Old

06-18-2014, 06:49 AM

whatsup

whatsup is offline

whatsup uses Windows 7 64bit

Windows 7 64bit whatsup uses Office 2010 32bit

whatsup uses Office 2010 32bit

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

whatsup will become famous soon enough

Default

Hi

You can determine by the entered decimals in B11 the calculation to be done. Like this:
=IF(LEN(B11)-FIND(".",B11,1)>2,B11-I7,B11-I6)

Reply With Quote