Steve Loft wrote:

Nick Gardner wrote:

Rain LTA %
77.0 64.3 ??

If rain is in A1 and LTA is in B1:

=A1*B1/100

Whoops, wrong way round - should be

=A1/B1*100

--
Steve Loft
Sanday, Orkney. 5m ASL. http://sanday.org.uk/weather
Free weather station softwa http://sandaysoft.com/
uk.sci.weather FAQs/glossary/etc: http://weatherfaqs.org.uk/