Apr 07 2022 10:40 PM - edited Apr 07 2022 10:49 PM
This is the question:
If 500 or fewer units are used, the cost is $0.02 per unit. If 501 – 1000 units are used, the cost is $0.02 for the first 500 and $0.04 for the remaining. If more than 1000 are used, the cost is $0.02 for the first 500, $0.04 for the next 500, and $.08 for the remaining.
a) Create a spreadsheet where a user can enter the number of electricity units used, and display the total cost.
This is my formula so far:
B8 is the units
B3 is 0.02
B4 is 0.04
I'm stuck on the last line of the question. Can I get some help, please? Thank you!
Apr 08 2022 03:26 AM
Solution@Rafat2045 TRy it this way, in order to avoid nested IF's.
The shaded areas are named ranges. Example file attached.
Apr 08 2022 03:26 AM
Solution@Rafat2045 TRy it this way, in order to avoid nested IF's.
The shaded areas are named ranges. Example file attached.