• 411K Members
• 5,127 Online
• 466K Conversations

New 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

# RE: Basic - opposite functions on excel

Can I use an IF statement in another cell to join the two together?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies