# if statement for +/- a percentage

#### marshy3300

##### Board Regular
Hello, I'm trying to display a tick or cross in F if a variance (D-C) is less than or greater than C but i'm having a total mind blank. Should be easy but its not!
I've got the wingdings side easily just the formula is stuffing me around

So

Num1 ...Num2 ...Variance.....Mark
C.............D............E...........F
600 ......600............0........Tick
13 ........14 ............1........Cross
312 ......308 ..........-4 ........Tick
312 ......388 ..........86 .......Cross
312 ......333...........21.........Tick

Last edited:

#### Michael M

##### Well-known Member
if a variance (D-C) is less than or greater than C
If that's the case....why is one of these a tick and the other a cross ???

312 388 86 Cross
312 333 21 Tick

#### marshy3300

##### Board Regular
86 (though my math sucks and should be 76) is greater than 10% of 312 so its a cross
21 is within the +/- 10% mark

Really bad day..... This is all based off +/- 10% variance from C

Last edited:

#### Michael M

##### Well-known Member
So this

Code:
``=IF(ABS(E1)< ABS(C1*0.1),CHAR(252),CHAR(251))``

Last edited:

#### marshy3300

##### Board Regular
Thanks Michael,

Looks like that only works if the variance is 0. Otherwise all the examples show wrong though the symbol does change over the course of the sheet
*
Amended - Wrong cell references... Works a treat
Thanks heaps

Last edited:

1,081,994
Messages
5,362,609
Members
400,684
Latest member
Vie

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...