This is my formula and I want to make C8 an absolute value (regardless of whether it is negative or positive). How do I do this? =IF(C8.50000000,3, IF(C8>25000000,2,IF(C8>5000000,1)))

I seem to remember something about dollar signs, but that didn't work either.

Thanks for any guidance and assistance.

Nathalie

Before I answer your question, I'd need to point out a couple of posting tips. First, please proofread your posts before you publish them. In both of your posts, you seem to be accidently using a "." instead of the "greater than" sign. Since we can only work with what we see, you should make sure that the formulas you post don't contain typographical errors.

Second, in your previous thread, I provided a solution that you appear to have accepted since you used it in this thread. It is considered proper netiquette to acknowledge the solution with some type of response letting us now that it worked for you. It's not that we need "thanks" for the help we offer (although that is nice also) it's more that it lets us know that a solution has been found so that oher's can learn from the solution too.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

There are 2 different meaning for "absolute" in Excel. One is Absolute Reference (using dollar signs) as described here:

http://www.cpearson.com/excel/relat...

The other is the Excel function which returns the absolute value of a number (ABS) as described here:

http://office.microsoft.com/en-us/e...

Remember to followup if we've answered your question.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ok, thanks for your advice and help. Much appreciated.

Ask Your Question

Weekly Poll