SheetsdrillOver budget?
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
If the actual cost is higher than the budget, the status is "Over". Otherwise it is "OK". Fill D2 and D3.
What this exercise teaches
IF turns a comparison into a label, so the status column stays right as the costs come in.
A hint if you get stuck
IF(test, value if true, value if false). Text results go inside double quotes.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise