Home

Basic - opposite functions on excel

%3CLINGO-SUB%20id%3D%22lingo-sub-861672%22%20slang%3D%22en-US%22%3EBasic%20-%20opposite%20functions%20on%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861672%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20create%20a%20monthly%20budget%20on%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20one%20cell%20(e.g.%20A1)%20I%20have%20the%20cost%20of%20my%20accommodation%20per%20week.%20In%20a%20separate%20cell(e.g.%20B1)%20I%20have%20the%20cost%20of%20that%20accommodation%20per%20month%20which%20I%20have%20calculated%20using%20the%20formula%20(%3DA1*4).%20Is%20it%20possible%20to%20have%20a%20function%20in%20B1%20so%20that%20I%20can%20input%20how%20much%20the%20accommodation%20would%20be%20per%20month%20and%20have%20A1%20display%20how%20much%20the%20accommodation%20would%20be%20per%20week%20(using%20%3DB1%2F4)%20so%20that%20I%20could%20input%20values%20into%20either%20cell%20and%20the%20other%20would%20give%20me%20the%20correct%20value%3F%20So%20the%20formula%20would%20be%20opposite%3F%20or%20is%20this%20not%20possible%3F%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861753%22%20slang%3D%22en-US%22%3ERE%3A%20Basic%20-%20opposite%20functions%20on%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861753%22%20slang%3D%22en-US%22%3ECan%20I%20use%20an%20IF%20statement%20in%20another%20cell%20to%20join%20the%20two%20together%3F%3C%2FLINGO-BODY%3E
haniya39
New Contributor

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
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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies