enlaotrapuntadelmundo
New Member
- Joined
- Jul 16, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
- Web
Hi everyone
I am creating a formula but it does not work well,to calculate different prices based at what time the electricity has being consumed in order to compare with cost of salr energy.I need to create a formula to compare differente prices,and at the moment, it does work but only with one condition, but not with three conditions (A1,A2,A3) I do appreciate any help
COLUMN A COLUMN B
A B
A1 Price 1 : 5$ Between 1 and 4 in the morning
A2 Price 2 : 10$ Between 4 and 7 in the morning
A3 Price3 : 8 $ Between 7 and 10 in the morning
Hour AM Consuption Kwh
A4 1 100
A5 2 150
A6 3 300
A7 4 90
A8 5 400
A9 6 300
A10 7 200
A11 8 90
A12 9 80
A13 10 70
A14 11 100
A15 12 50
I need to get the total price per hour
If the hour Column A (A4:A) is between 0 and and 4 , multiply cells in column B (B4) (100 kwh,150,300...etc) by A1 (5 dollars)
If the hour A4:A is between 4 and 7 , multiply column B B4:B (100 kwh ,150,300...etc)) by A2 (10 dollars)
If the hour A4:A is between 7 and 10 , multiply column B B4:B (100kwh,150,300...etc) kwh) by A3 (8 dollars)
I am using formula
=IFS(A:1:A>0,B4*$A$1;B4:B<4 but I am having issues , and if i use with if same issues with ifs, if and formula if (and), I spent 03 hours but definitely I can not do it alone.
Thanks for any help
JJ
I am creating a formula but it does not work well,to calculate different prices based at what time the electricity has being consumed in order to compare with cost of salr energy.I need to create a formula to compare differente prices,and at the moment, it does work but only with one condition, but not with three conditions (A1,A2,A3) I do appreciate any help
COLUMN A COLUMN B
A B
A1 Price 1 : 5$ Between 1 and 4 in the morning
A2 Price 2 : 10$ Between 4 and 7 in the morning
A3 Price3 : 8 $ Between 7 and 10 in the morning
Hour AM Consuption Kwh
A4 1 100
A5 2 150
A6 3 300
A7 4 90
A8 5 400
A9 6 300
A10 7 200
A11 8 90
A12 9 80
A13 10 70
A14 11 100
A15 12 50
I need to get the total price per hour
If the hour Column A (A4:A) is between 0 and and 4 , multiply cells in column B (B4) (100 kwh,150,300...etc) by A1 (5 dollars)
If the hour A4:A is between 4 and 7 , multiply column B B4:B (100 kwh ,150,300...etc)) by A2 (10 dollars)
If the hour A4:A is between 7 and 10 , multiply column B B4:B (100kwh,150,300...etc) kwh) by A3 (8 dollars)
I am using formula
=IFS(A:1:A>0,B4*$A$1;B4:B<4 but I am having issues , and if i use with if same issues with ifs, if and formula if (and), I spent 03 hours but definitely I can not do it alone.
Thanks for any help
JJ