How we make Electricity bill in Excel?

Hi Friends,

In my university teacher gave me lesson about Making Electricity bill but i don't how i can create can you help how i can make?

Comments

  • well first you need to konw the data..

    What are you calculations, What is the cost per watt, how many watts are used, any other fees? your asking us to answer something we have no data on..
  • Look Condition.
    1-If >0 and <50 Rate Units:2$
    2-if > 51 and <150 Rate units:4$
    3-if >151 and <300 Rate Units:6$
    4-if <300 Rate units:10$

    Which our Teacher explain with us Formula but i am totally confused because this formula not working yet.

    =IF(D1<=50,D1*2,IF(D1<=150,100+(D1-50)*4,IF(D1<=300,100+400+(D1-150)*6,IF(D1>303,100+400+900+(D1-300)*10))))
Sign In or Register to comment.