#VALUE! Error

[ASolo]

I am wanting to add a few columns with SUM(I5+.....etc). The Value error tells me that there are some cells that contain words but there aren't any they are all numbers?
When I use the formula with SUM(I5:P5) (or whatever...) it leaves a few cells out that have formulas on their own, it will only add them in if I override the numbers, I know i am way from being a Pro, maybe this is an easy one for you guys. Please HELP !!

[BadlySpelledBuoy]

Could you post a sample workbook?

[ASolo]

Ok, I hope this works.Sample.xlsx

[boopathiraja]

HI, Probably no stores as text causing the error

[boopathiraja]

if so try this

Please Login or Register  to view this content.

[/FORMULA]

[boopathiraja]

the formula in m5 causing the error

Please Login or Register  to view this content.

[ASolo]

No, It just changed the error to #NAME?

[boopathiraja]

Remove the doule quotes which is treating as text and enter it as values

Please Login or Register  to view this content.

[ASolo]

no, that only gives me another giant error message and I have to force an end to even x out of it :-(

[boopathiraja]

You syntax should be like this in m5, expand it accordingly it will work

Please Login or Register  to view this content.

[boopathiraja]

No need to put "$" and all inside the formula its a matter of cell formating

[ASolo]

no, can't get it to work at all, took all the $ out, took all the " out, replaced all the ; with , to make it look just like yours..... it will not work for me..... put all the ; back in.... nothing works, the giant error is my best friend at this point. Getting ready to give up

[BadlySpelledBuoy]

In your nested IFs in columns J & M use periods rather than commas. So $2,94 is $2.94. And as mentioned in a post above get rid of the "'s and $'s in these formulas. =IF(H5<2,1.47,IF(H5=2,2.94 etc
Then you should have no problems.

Worth noting that these nested IFs are not particularly efficient from a calculation point of view and make life difficult if you ever need to update the values.
Far easier to use small lookup tables hidden away in the workbook.

BSB.

[boopathiraja]

No, Don't give up wait for few min, i will post the file with formulas updated..

[boopathiraja]

Hi, Ref the attachment

[boopathiraja]

Hope it helps

[ASolo]

Thank you so much, I will check and see what I did wrong. Big Fat Smiley Face

[boopathiraja]

HI, Thanks for the feedback ,

You can mark the thread as solved