IF Formula when one cell's value is the result of a formula.

[Liam_1988]

Hi,

This is probably a little low brow for you but I'm super desperate.

I've tried using IF, AND & EXACT formula's to try and get a result but I'm getting nowhere.

Bellow is the data set:

Cell 'BO' has the formula - =IF(COUNTIF(K2:S2,"N/A")=$BT$8,"N/A",IF(COUNTIF(K2:S2,"Yes")+COUNTIF(K2:S2,"No")=$BT$8,ROUND(COUNTIF(K2:S2,"Yes")/$BT$8,2),"Error"))
Which is working as it should however in cell 'BP' it should cross reference the value in cell 'BG' against the value in cell 'BO' and I used the formula '=IF(BG2=BO2,"Match","Error")'. Even thought the 2 cell values match the formula in 'BP' doesn't work. Any ideas?

* BT8 = Total number of Question's so as to calculate the % for cell 'BO'.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

AH

AI

AJ

AK

AL

AM

AN

AO

AP

AQ

AR

AS

AT

AU

AV

AW

AX

AY

AZ

BA

BB

BC

BD

BE

BF

BG

BH

BI

BJ

BK

BL

BM

BN

BO

BP

BQ

BR

1

Created By

Compliance Monitor?

Date of Call?

MPN?

Advisor?

EIN?

TM

CSM?

DPA

Type of call?

Q1

Q2

Q3

Q4

Q5

Q6

Q7

Q8

Q9

Comp 1

Comp 2

Comp 3

Comp 4

Comp 5

Comp 6

Comp 7

Comp 8

Comp 9

Comp 10

Comp 11

Comp 12

Comp 13

Comp 14

Comp 15

Comp 16

Comp 17

Comp 18

Comp 19

Comp 20

Comp 21

Comp 22

Comp 23

Comp 24

Unfair Outcome

What Type of Unfair Outcome?

Compliance Pass/Fail?

GDPR Pass/Fail?

GDPR Fail reason?

Insurance Pass/ Fail?

Insurance Failure Reason?

Trans ID

Date Feedback Given?

Date Response Required?

Feedback Given?

Call Back Required?...

Call Library?

Item Type

Path

Sales Execution score

Reason for PAC/STAC fail.

PAC/STAC Pass/Fail?

Coverage check completed (must include 5G)?

Did the customer display any dissatisfaction ?

Name Check - Advisor

Name Check - TM

Name Check - CSM

Calculated Score

Sales Excecution

Calculated Compliance

Compliance Result

2

Agent 1

Agent 1

01/01/2020

07000000000

Advisor 1

800000000

Manager 1

CSM 1

Fail

Viz

No

Yes

Yes

No

No

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

N/A

Yes

Yes

Yes

Yes

No

Fail

Pass

Pass

100000000

02/01/2020

03/01/2020

Didn't confirm surname on outbound calls

No

Item

sites

67%

Yes

Agent 1

Manager 1

CSM 1

67%

Error

Fail

Match

 

[Fluff]

How about

=IF(ROUND(BG2,2)=ROUND(BO2,2),"Match","Error")

 

[Liam_1988]

That's brilliant! Thank you.

I didn't even give 'ROUND' a second thought in truth.

Really appreciate your help .

 

[Fluff]

You're welcome & thanks for the feedback.