How do i make a formula using cells (divide B3/B5)

A

ace8707

I am trying to get excel to divide cell B3 by B5. I have been entering in
=B3/B5 and it keeps giving me #VALUE!. I also need to drag the formula down.
I thought this was how to do it but apparently im wrong. A little help
would be much appreciated.
 
D

daddylonglegs

Perhaps you have text in B3 or B5 (even if they look numeric)?

If you drag the formula down you'll get

=B4/B6 in the cell below, if you want to keep one of the values the
same use something like

=B$3/B5

when you drag this down it becomes

=B$3/B6 in the cell below
 
G

Gilles Desjardins

I hope that you are writing this formula in another cell. i.e. in C5. It
works for me. Are B3 and B5 text values? Maybe?

Gilles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum based on value in a range 0
IF function says too many nested 1
How to check if the values in a range of cells are greater than 0 3
how do I search thru the values in my column and replace with nessesary values 1
Autofiller Tool Help 4
I have either a H or A in cell B5. 2
Formula question?? 14
Pasting Formula Based on 2 Existing Formulas 2

Top