Solved

Sum returning wrong value

Posted on 2014-10-13
72 Views
Last Modified: 2014-10-13
Can anyone tell me why cell aa in row 75 is returning a value of 11 instead of 12?
THS-Supplier-Partnership-Criteria.xlsx
0
Question by:robmarr700
3 Comments

LVL 4

Expert Comment

ID: 40377149
Your document is linked to other external documents. Are they related and needed to your cell AA?
0

Author Comment

ID: 40377158
Some of the values have been pulled using Vlookups from other excel documents. These values are needed. Ideally I don't want to paste as values as the values on the external sheets may change.....
0

LVL 48

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 40377171
Hi,

in Col W change your formula to

=IF(V75>0,1,IF(V75<=0,0))

instead of your old formula which have text "1"

Regards
0

Join & Write a Comment Already a member? Login.

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!