Posted by DannyG 6 years ago In:

, , ,

DannyG
DannyG Asked:

Cell format needed

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.

Liked this question? Tell your friends about it

Answers

ashok_tt
ashok_tt Answered:

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.  

Add a comment Report

Related Questions

Other people asked questions on similar topics, check out the answers they received:

davemctavi

Asked: Office home and student 2010. I sent an Excel ...

office home and student 2010. I sent an Excel spreadsheet from work. I can add more info but I can't save the new numbers. Do I have to rename it because of the changes ? How do I do that ?
  • Posted 7 months ago
FC

Asked: Excel, Formulas

Hi all, I'm hoping for some help asap on an Excel formula I am working on. In column A I have reference nos for issues brought to my attention. In column B I have the year the issue was 'opened ...
  • Posted by FC 3 years ago
JO

Asked: Excel

How to use excel copy & paste
  • Posted by JO 5 years ago

More Questions

How can i tell if a cell phone is turned off

If you call a cell phone and it is turned off, the call may go to voice mail. But if the cell phone is in use, the same thing would happen, so you can't tell.

Incorrect Format. Need Help.

Hi, Darryl: Please let me know if you're using Webmail or the AOL Desktop software. If you're using Webmail, please contact our Mail Support Team here: http://t.co/0a6HwpM If you're using the AOL Desktop software, have you tried uninstalling and reinstalling the software? Thank you.

Activating a knockoff cell phone. I bought a ...

Your options are to either toss it in the garbage or use it as a paperweight. Another option is to buy a real phone.