- Joined
- Jun 12, 2011
- Messages
- 2
- Reaction score
- 0
- Points
- 1
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:
and
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
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)
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)))
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