A=5 years precipitation divided by the value of 60
B=each average rainfall
Have great god know how to read the Exlce file and then calculate the sum of 5 precipitation in divided by 60, with/a (b - a) finally the formula to calculate each precipitation

CodePudding user response:

Randomly choose a cell
Calculate a fx rules written=SUM (A6: A19)/60
Calculate b write=AVEDEV fx rules (A6: A19)
Calculate write=c fx rules (B1 - C1)/B1