Forum Discussion
Solved
Excel sheet where a user can enter the number of electricity units used, and display the total cost
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 a...
Rafat2045 TRy it this way, in order to avoid nested IF's.
The shaded areas are named ranges. Example file attached.
Rafat2045 TRy it this way, in order to avoid nested IF's.
The shaded areas are named ranges. Example file attached.