=(1/A2876000B2)/C2*100
Do I need the % sign after the 100? As it makes a big difference. lol
=(1/A2876000B2)/C2*100
Do I need the % sign after the 100? As it makes a big difference. lol
Assuming a2 , b2 and c2 are linked to the requested values you could remove the “*100” and set the field value on %.
But yeah times 100 gets you percentage if the remainder of the formula is correct.
One check did you include the * after A2 and before B2? So rather than
=(1/A2876000B2)/C2100 i would expect; =(1/A2876000B2)/C2100
What numbers did you enter and what is your result? I will calculate it myself with your numbers to double check 👍
A2 = 3130 total stakes miners
B2 = 0.00317 price in hive of 1 bbh today - release price
C2 = 2 Price in Hive of 1 Miner