Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel for Mac giving me #VALUE! for everything
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="glossolalia" data-source="post: 1251706" data-attributes="member: 204553"><p>Hi guys,</p><p></p><p>I have a spreadsheet that was originally made for PC's (I'm assuming) and I'm trying to use it on a Mac. Thing is, the sheet uses a custom function and some of the formulas are kind of complicated.</p><p></p><p>Two examples are:</p><p></p><p>[CODE]=GetURLmetrics(A10,TRUE)[/CODE]</p><p></p><p>and</p><p></p><p>[CODE]=MID($B10,(FIND(C$9,$B10)+LEN(C$9)+1),(FIND(",",$B10,(FIND(C$9,$B10)))-FIND(C$9,$B10)-(LEN(C$9)+1)))[/CODE]</p><p></p><p>Could it be that the formulas are supposed to be written differently on a Mac vs. a PC? If so, could someone point me in the right direction? If these are written incorrectly, how would I change them to make them valid for Excel on Mac?</p><p></p><p>Thank you,</p><p></p><p>Brandon</p></blockquote><p></p>
[QUOTE="glossolalia, post: 1251706, member: 204553"] Hi guys, I have a spreadsheet that was originally made for PC's (I'm assuming) and I'm trying to use it on a Mac. Thing is, the sheet uses a custom function and some of the formulas are kind of complicated. Two examples are: [CODE]=GetURLmetrics(A10,TRUE)[/CODE] and [CODE]=MID($B10,(FIND(C$9,$B10)+LEN(C$9)+1),(FIND(",",$B10,(FIND(C$9,$B10)))-FIND(C$9,$B10)-(LEN(C$9)+1)))[/CODE] Could it be that the formulas are supposed to be written differently on a Mac vs. a PC? If so, could someone point me in the right direction? If these are written incorrectly, how would I change them to make them valid for Excel on Mac? Thank you, Brandon [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel for Mac giving me #VALUE! for everything
Top