asked on # Excel - Compute Third Field Given Two Others

I know how to do this programmatically but I wonder if I can do this using only formulas... it's not obvious to me.

Referring to the image below, I want to be able to calculate the field with no entry when the other two are filled in.

The overall formula is Cap Rate = Income / Price... so if someone enters income and price, I'll compute the cap rate, if they enter cap rate and price, I'll compute compute income and so on.

At this point, the only way I can see to do it is to have a second set of fields below the first that contain the formulas. Any other thoughts or am I going to have to add a "Compute" button and a chunk of VBA code?

TIA

Referring to the image below, I want to be able to calculate the field with no entry when the other two are filled in.

The overall formula is Cap Rate = Income / Price... so if someone enters income and price, I'll compute the cap rate, if they enter cap rate and price, I'll compute compute income and so on.

At this point, the only way I can see to do it is to have a second set of fields below the first that contain the formulas. Any other thoughts or am I going to have to add a "Compute" button and a chunk of VBA code?

TIA

Microsoft Excel

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.