Forum Discussion
haniya39
Sep 18, 2019Copper Contributor
Basic - opposite functions on excel
I am attempting to create a monthly budget on excel.
In one cell (e.g. A1) I have the cost of my accommodation per week. In a separate cell(e.g. B1) I have the cost of that accommodation per month which I have calculated using the formula (=A1*4). Is it possible to have a function in B1 so that I can input how much the accommodation would be per month and have A1 display how much the accommodation would be per week (using =B1/4) so that I could input values into either cell and the other would give me the correct value? So the formula would be opposite? or is this not possible?
Thanks for any help
1 Reply
- haniya39Copper ContributorCan I use an IF statement in another cell to join the two together?