Recent content by Jmaddog

Thank you so much for all your help. It is working. This is going to save so much time. Thanks again.

What if we have DIV/0! inplace of "0" how would we write this in the formula?

Here it is, it is going to be confusing, it is a weighted average: =(H7*(0.2)+J7*(0.05)+L7*(0.1)+N7*(0.25)+P7*(0.15)+R7*(0.1)+T7*(0.15))

How can we incorporate this formula if we already have a formula in the total cell (a6)?

This is close. How do we calculate the ranking if we have "0" in one of the cells, but we do not want to include the "0" as part of the ranking. Currently the formula calculates the "0" in the ranking.

Please help with excel formula question: Working on an efficiency ranking spreadsheet including the following: There are six categories. Each has a ranking 1-5, 5 being the best. Those categories are all weighted and added together for the total ranking, which is your outcome. If there is no...

Please help with excel formula question: Working on an efficiency ranking spreadsheet including the following: There are six categories. Each has a ranking 1-5, 5 being the best. Those categories are all weighted and added together for the total ranking, which is your outcome. If there is no...

They are actual numbers, the numbers only have one decimal place. ex 4,610.256 (4,610,256)

the numbers only have one decimal place. ex 4,610.256 (4,610,256)

These are actual numbers not text

I don't think that will work. Some numbers are 100's (0.125)

Is there away to convert decimal places as 1,000s? My numbers are currently 15.031 (which is 15,031).

Thank you very much - that worked. I appreciate everyone's help on this.

Thanks for the responses. My problem is that I about 1500 records that I need to convert to positive numbers and the numbers are not the same. I am not following the Abs function. Can someone please provide me with more detailed instructions on how to do this function. When I try - I end up...

I have an excel file that has numbers stored as negative numbers. How can I convert the number to a positive?