* How can I Multiply DnaRelatedness by a Number

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
Post Reply
User avatar
paultt
Famous
Posts: 116
Joined: 18 Jan 2005 21:59
Family Historian: V7
Location: Hampshire, England
Contact:
Contact paultt

How can I Multiply DnaRelatedness by a Number

Post by paultt »

In a query I am trying to get a cM value using =DnaRelatedness(FileRoot(),%INDI%) which gives a float value less than 1.
How can I multiply that result of say 0.5 by 6900 to get a cM value of 3450 ?
I thought =Calc(DnaRelatedness(FileRoot(),%INDI%)*6900) but that errors.
What am I missing?
Thanks
Top
User avatar
Jane
Site Admin
Posts: 8518
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:
Contact Jane

Re: How can I Multiply DnaRelatedness by a Number

Post by Jane »

Try

Code: Select all

=Calc(Float(DnaRelatedness(FileRoot(),%INDI%)) * Float(6900))
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
Top
User avatar
Ron Melby
Megastar
Posts: 928
Joined: 15 Nov 2016 15:40
Family Historian: V6.2

Re: How can I Multiply DnaRelatedness by a Number

Post by Ron Melby »

those formulas are not my forte but will this work?

=Calc( (DnaRelatedness(FileRoot(), %INDI%) or 0) * 6900
FH V.6.2.7 Win 10 64 bit
Top
User avatar
paultt
Famous
Posts: 116
Joined: 18 Jan 2005 21:59
Family Historian: V7
Location: Hampshire, England
Contact:
Contact paultt

Re: How can I Multiply DnaRelatedness by a Number

Post by paultt »

Brilliant, Jane,
Thanks very much.
Top
Post Reply

Return to “General Usage”