# Basic Formula trouble

#### rich197803

##### New Member
Hi,

Sorry for such a basic set of questions, I normally can make Excel do the basic things I need, however I am struggling with what normally is very easy stuff.

If cell D6=8 and D8=0.7, under what circumstances would a formula in cell D9 (which is formated to be a number with two decimal places) of =D6*D8 show as 0?

If cell D3=1.00 why would the cell D11 show as 0 when it has the following formula? =IF(D3=0.5,0.5,1)

If cell D13=4 and cell D11=0, why would cell D14 show as 1.5 when the formula is =D13-D11

I have other similar issues but I am hoping they will be solved when the above issues get sorted.

Any help would be great. (I can send the excel spreadsheet as well but I can not see an attachement option? (but the why my day is going probably means I am looking past it))

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### Weaver

##### Well-known Member
Are you sure none of these numbers aren't stored as text?

Replies
5
Views
172
Replies
11
Views
318
Replies
1
Views
126
Replies
3
Views
161
Replies
3
Views
439

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,686
Messages
5,833,119
Members
430,194
Latest member
dbow2226

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back