Excel formula goes red and gives answer 0

[willekins1]

Hi,
I am trying to divide on excel, but every time I do, the second cell goes red in the formula as seen in photo and the answer comes out as zero. Is there a way I can fix this? Thanks

H

 

[MARK858]

You are trying to divide D7 by the cell the formula resides in or the cell below?

 

[willekins1]

You are trying to divide D7 by the cell the formula resides in or the cell below?

Hi I am trying to divide D7 by D11, and putting the formula in D12, I also tried in D13 and had the same thing.

 

[Fluff]

Hi & welcome to MrExcel.
Are those values numbers formatted to show a B or is the B in the actual cell making them text?

 

[MARK858]

What is the cell formatted as? I ask because my result is below

Test Workbook .xlsb
	D
7	49.55
8
9
10
11	101.29
12	0.489189
13
Sheet5

Cell Formulas
Range	Formula
D12	D12	=D7/D11

 

[willekins1]

Hi thank you.
The B is to show billion. The weird thing is that I have another set of data in the same way just for a different country a few rows down in the same columns, and when I tried to do it for that set of data, the cell went red again but it gave the correct answer, just without the B so I'm not sure why one works and the other doesn't. When I open format it says general

 

[MARK858]

The B is to show billion. The weird thing is that I have another set of data in the same way just for a different country a few rows down in the same columns, and when I tried to do it for that set of data, the cell went red again but it gave the correct answer, just without the B so I'm not sure why one works and the other doesn't. When I open format it says general

Fluff is asking if you have typed the B in my hand, in which case you have made the cell text and not a number.

 

[willekins1]

Ok so I copied that data set and pasted it about 10 cells down and it is now working... Not quite sure what the issue is but it works when moved down so that's ok. Thanks for the help

 

[RoryA]

It might just have been the number format of the formula cell.