Cell A1 can be answered as either "Yes" or "No" from a drop down menu
Cell A2 must be a numerical value ranging from 1 to 100
Cell A3 is a fixed cost of $150.00
Cell A4 must equal a multiplication of cells A2 and A3, but only if Cell A1 is answered as "Yes". If Cell A1 is answered as "NO" then Cell A4 must equal "0"
In theroy the scenario would go like this in the sheet: If I have to repair a car I would click "Yes" in cell "A1" and then in cell "A2" I would type in that I had to fix "2" cars and then Cell "A4" would automatically tell me the total price for repairing "2" cars is $300.00. If I clicked "No" in cell "A1" that I didn't have to repair any cars then cell A2 would not need to be filled in and Cell A4 would remain blank, or stay as "0". In both of these scnarios Cell A3 is hidden.
Sign In
Create Account
