![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
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) + ... |
#3
|
|||
|
|||
![]()
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!!!!!
|
#4
|
|||
|
|||
![]()
You're welcome.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
piper7971 | Excel | 10 | 07-06-2015 02:09 PM |
![]() |
njweatherdon | Word | 2 | 09-22-2014 09:06 PM |
![]() |
gbaker | Excel | 1 | 04-26-2014 12:31 AM |
![]() |
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 |