Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-18-2014, 06:49 AM
whatsup whatsup is offline Help with IF or ELSE Formulas Windows 7 64bit Help with IF or ELSE Formulas 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
Help with IF or ELSE Formulas Save Formulas bondimedical3 Word 7 04-25-2012 02:02 AM
Help with IF or ELSE Formulas Formulas in a different language poobear Excel 2 09-18-2011 04:35 AM
Help! 'SUMIF' Formulas dave1372 Excel 2 09-08-2011 07:05 AM
Help with IF or ELSE Formulas IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft