Thanks for looking. I found one that worked like I needed it to, maybe a
little more involved but good non the less. Thanks for your input and time.
Greg

"Rick Rothstein" wrote:

With meter reading in A1 and Temperature in B1 enter in C1
=A1+A1*ABS(A2-65)*0.002488*(SIGN(A2-65))

Unless I am missing something, I think your formula is equivalent to this...

=A2+A2*(A3-65)*0.002488

--
Rick (MVP - Excel)


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
hi Greg

With meter reading in A1 and Temperature in B1 enter in C1
=A1+A1*ABS(A2-65)*0.002488*(SIGN(A2-65))

--
Regards
Roger Govier

"greg" wrote in message
...
I am working on a spreadsheet for calculating natural gas usage. Our
meters
aren't temperature adjusted so I need to incorporate a calculation in our
spreadsheet that takes the temperature we input and adjusts our gas usage
accordingly.
The temp. factor sheet I have goes from -20 degrees to 139 degrees. I am
mainly concerned with 30 degrees (meter reading*1.0612) to 110 degrees
(meter
reading*.9123), 60 degrees being meter reading * 1. The factor increase
from
30 to 59 is .002488 per degree (60 is not corrected) and then at 61
degrees
and above the factor decreases by the same .002488.
Any help or suggestions would be greatly appreciated.
Thank You,
Greg