I'm working in excel and would like to have a value that I input in the currency Birr be divided by 9.1. e.g. I input 14,000 in B1 and want it to divide by 9.1 and display the answer. I'd then need to copy this formula for multiple columns. Any suggestions?
Thanks.
You should choose a target cell, lets say B2. click on B2 and type = . then go back to B1 and type /9.1
to copy this formula just drag the cell from the lower left corner.
Got an answer for DannyG? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
Other people asked questions on various topics, and are still waiting for answer. Would be great if you can take a sec and answer them
