Basic Formula trouble

rich197803

New Member
Joined
Aug 6, 2010
Messages
1
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
Joined
Sep 10, 2008
Messages
5,196
Are you sure none of these numbers aren't stored as text?
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top