Can I convert my spreadsheet to mmol/L?

[Bucasmom]

Here's a link to my condo in the Tech Support section

viewtopic.php?f=6&t=74321

My spread sheet has two months worth of data on it, but I need to convert it all to mmol/L for my vet visit today... when I click on mmol/L it comes up with a blank spreadsheet... I can go back to the US mg/dl and all my info is there still... I'm afraid to copy and paste it or do anything as I don't want to lose all our data nailbite_smile

 

[hmjohnston]

Try this-
on your mmol/L tab, starting in the AMPS column go to the first open slot and type in
=round(
then click over to the US tab and go to the same box and click that same box
go back to the world tab and finish with
/18
You may need to add a
,0)
at the end to get it to work properly. Basically you are telling it to use the first number and divide it by 18.

This is how it should look-
=round('US mg/dl'!D4*18,0)

this should convert whatever number is in the first tab to your number.
Then, highlight the box and place your pointer/cursor on the little blue box and hold down a L-click and drag it down.

Copy and paste the first box to the +1 boxes, check to make sure the correct r/c # is being used and copy it over the columns and then down the rows as needed.

I'll stay on the computer if you want to get back with me on problems.

 

[Bucasmom]

It worked and it looks so pretty and colourful haha.

Thanks again!