Need some Mathematical help

[mr mahoney]

Making a spreadsheet to show cost on making items such as kegs but I seem to have some math issues with the excel formula.

Example using to average the cost to make 1 deadly poison keg

so reg cost of 3gp
total potion in 1keg= 100
regs to make 1 potion= 8
% chance to suceed 20%

so i used

Code: Select all

(3gpx100x8)+ (1-.2)x(3gpx100x8)= 4320gp

which seems pretty low on actual cost I am assuming I have something wrong with accounting for chance failure and succession if someone could enlighten me that would be great.

[Samorite]

carnt see anywhere "regs to make 1 potion= 8"

and if you rap your formula with code tags

Code: Select all

it will not have any smileys in :)

[mr mahoney]

got it figured out thanks