Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2015, 07:01 PM
Frenchy305 Frenchy305 is offline Formula works in Excel on my computer, but not on my PDA Windows 10 Formula works in Excel on my computer, but not on my PDA Office 2013
Novice
Formula works in Excel on my computer, but not on my PDA
 
Join Date: Dec 2015
Location: Indiana
Posts: 4
Frenchy305 is on a distinguished road
Default Formula works in Excel on my computer, but not on my PDA

The formula:
=IF(B1="","",8.55+LOG(B3-B2/4)+0.033*((B1-32)*5/9-25)) works just fine on every excel version I use. But when I try to enter it into my Palm Tungsten E2 PDA I get the error message: "Function contains too few arguments" and the ) after the 4 is highlighted as a problem. My PDA uses DataViz Sheet to Go and it's supposed to be creating native Excel Files. And the spreadsheet works just fine with other less complicated formulas. My cell format options are General, Fixed, Scientific, Currency, Percent, Text, Date, and time. And I have the format option set at General. Please help me.....thanks.
Reply With Quote
  #2  
Old 12-16-2015, 10:57 AM
shg shg is offline Formula works in Excel on my computer, but not on my PDA Windows 7 64bit Formula works in Excel on my computer, but not on my PDA Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

Perhaps (just guessing), your PDA's version of Excel requires the LOG function's optional base argument to be specified:

... + LOG(B3-B2/4, 10) + ...
Reply With Quote
  #3  
Old 12-16-2015, 04:12 PM
Frenchy305 Frenchy305 is offline Formula works in Excel on my computer, but not on my PDA Windows 10 Formula works in Excel on my computer, but not on my PDA Office 2013
Novice
Formula works in Excel on my computer, but not on my PDA
 
Join Date: Dec 2015
Location: Indiana
Posts: 4
Frenchy305 is on a distinguished road
Default Very Good Educated Guess!!!

My PDA has a LOG(number, base) option in the function dropdown menu, but I didn't know quite how to enter the numbers. Duh...pH being Log base 10. Thank you so very much for your assistance!!!!!
Reply With Quote
  #4  
Old 12-17-2015, 08:33 AM
shg shg is offline Formula works in Excel on my computer, but not on my PDA Windows 7 64bit Formula works in Excel on my computer, but not on my PDA Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

You're welcome.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula works in Excel on my computer, but not on my PDA formula in excel 2007 works not in 2013 piper7971 Excel 10 07-06-2015 02:09 PM
Formula works in Excel on my computer, but not on my PDA An html link from Excel works, but now there is too much extra space in the cell njweatherdon Word 2 09-22-2014 09:06 PM
Formula works in Excel on my computer, but not on my PDA Formula works on most cells gbaker Excel 1 04-26-2014 12:31 AM
Formula works in Excel on my computer, but not on my PDA Scrolling wheel in Excel shuts down my computer... lazlow Excel 1 11-01-2011 10:59 AM
Computer Stolen-Install Office 2007 On New Computer corndale Office 0 08-23-2010 09:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.


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