sign

Hello, I would like some help with a formula that tells me the difference between numbers in two cells but does so with a + or – sign depending on whether the number is lower than or higher than the cell I am looking at. For example, I have, in Cell F9, the number 84 and in cell G9, the...

Sorry, but I can find a place to ask a MRExcel site question, so here it is. When I used to sign in I had a home page that had my user name, it would say Welcome SeniorTom and a way to sign out. From there I would go to the forums. In the upper left was the MRexcel logo and the logout and...

Looking online, I found the command below to turn negative currency red with a negative sign, but it didn't work for me. The result I got is red currency with no negative sign. $#,##0.00;[Red]-$#,##0.00 Can anyone help me please? TIA!

How to select smallest value from the range given ignoring the sign.

Hi, I am using the sign formula in column N. I only want to show the arrows if J2 does not =0. I have tired amending my formula from =SIGN(M3-D3) to =if(J2<>"0",SIGN(M3-D3),"") but the arrows are still showing. Anyone with any ideas?

=SUMPRODUCT(SIGN((APR'!$A$3:$A$2500&APR'!$B$3:$B$2500="Place holder"&$B$2)*(APR'!$I$3:$I$2500<>"R"))) for the most part this formula works but in Collumn "I" I want to exclude Value "R", the problem is it is also excluding the value RBS which I don't want. This has to be a sumproduct formula...

Hello, Does any one know of the proper sumproduct function that's a conditional sum (lookup) without including the duplicates please? I believe it includes the SIGN function within: <tbody> Product Group Level Model Count Boundless 1 101 3 Boundless 1 102 3 Brewery 1 101 8 Brewery...

I am using Excel 2003 in the UK - where shift+3 is a pound sign (£) However, occasionally (and seemingly randomly) Shift+3 produces a hash sign (#). I have researched many forums online and the common 'solution' is suggesting to check that the Microsoft Office local language setting is UK (and...

Hi, I have a set of 5 cells (a row vector), each cell containing a number from -1 to +1. Reading through the values from first to last, I want to count how many times it changes sign (i.e. from positive to negative or vice versa). Zeros are present but need to be ignored (skipped). For example...

Hello, i got here a peace of mine code: this should check if the data is equal to Q1 but it is only for 2010 but i need from 2000 tot later (lets say 2100) but i dont want to copy and paste because my total program has already over 1500 lines so i would like something like this: but the...

I am after some sort of macro that will help me track work flow between users with some specific caveats. I'm not sure that what I want to do can be done with normal track changes so I may be in need of a macro and since my macro skills are quite basic I'm after some help. Thanks in advance...