here is my problem:
if a meter reading is less than 400 kwh from previous reading then * 0.0725, if the reading is more than 400, then (400 * 0.0725) plus the (remainder * 0.095).
thank you in advance.
I would, if possible, get a notice when an answer is posted. djnosnow@aol.com
thanks again
djnosnow
Hi,
Assuming meter reading movement is in A1 then
Formula:
=MIN(400,A2)*0.0725+(MAX(400,A2)-400)*0.095
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Excellent Mr Buttrey.... works like a charm
OK, glad to have helped and thanks for the rep.
Since that appears to have taken care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks