X Marks the Scot - An on-line community of kilt wearers.
-
20th June 08, 11:45 AM
#1
 Originally Posted by Wolfgore
I am not very good with excel.
Is there anyone out there that can convert Mipi's fine work over to inches for us?
If anyone is able to do so, send me a PM, I will send you my email addy and you can send it to me and I will post it as well.
Gary
PM on its way. I'm working to see what I can do with it.
 Originally Posted by Canuck
unprotect the spreadsheet under the tools menu
select a free column. reference the column and insert a formula for example =b2/2.54 for waist
=b3/2.54 for hip.
there are 2.54cm in an inch or you can do the reverse .... multiple the inch measurement by 2.54 to get the centimeters
You can't just do that because of some of the formulas that work together. It'll throw the recommendations off.
-
-
25th June 08, 11:29 PM
#2
I woud suggest two things:
- use inch covertion seppartely not to mess with IF statements
- protect worksheet back to be sure you're not doing any fulish thing and destroy formulas
I'll try to do something in inchis when I find some time. But don't think I'll to any fractions!
-
-
26th June 08, 05:26 AM
#3
 Originally Posted by Mipi
I woud suggest two things:
- use inch covertion seppartely not to mess with IF statements
- protect worksheet back to be sure you're not doing any fulish thing and destroy formulas
I'll try to do something in inchis when I find some time. But don't think I'll to any fractions!
I sent a modified file to Wolfgore. Don't know if he's had the chance to do anything with it yet. I could send it to you to verify if you'd like. If so, PM me your email.
-
-
27th June 08, 01:42 AM
#4
As a fact, I sent the inch version already to Wolfgore. Maybe he can compare to find any errors/differences, or decide which to post. In case of doubt, he can send me your version and I'll see...
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Bookmarks