create a calculation

i have these data, i need to create a calculation.


This is my current values.

Spends - ₹4,853.00 spends = units * acpu
Revenue - ₹1,21,655.32 revenue = ASP * units
Clicks - 1380 clicks = spends / cpc
Units - 615 units = spends / acpu
ACPU - ₹8 ACPU = spends / units
CPC - ₹3.52 cpc = spends / clicks
ASP - ₹197.81 asp = revenue / units



Here the main Question.

if i increased or decrease spends number then automatically it should calculate and give me rest of all the numbers. same way if i increase or decrease the units value then automatically it should calculate and give the rest of the numbers. same way if i change any feilds then the rest of the feilds should get calculated and give me the numbers.


i don't need multiple calculator i just want in a single calculator which all the fields should get calculated.


can some please help me how do i create this in excel.


thanks in advance.

4,853 or 4,920 thats okay its just an aprox spends so not an issue.

the calculator should so like this

Example 1 if i increase or decrease my units lets say from 615 to 1500 then the calculator should show me what will be the spends, cpc, and other metrics, with the same ASP.

Example 2 if i increase or decrease my ASP then what will be the units, spends and other metrics.

To get 625 units i spent 4920 and each costed me 8. so if i want o get 500 units then what will be my spends and what will me my ACPU.