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

#### Liam_1988

##### New Member
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

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=IF(ROUND(BG2,2)=ROUND(BO2,2),"Match","Error")``

#### Liam_1988

##### New Member
That's brilliant! Thank you.

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

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
1
Views
107
Replies
5
Views
102
Replies
3
Views
71
Replies
1
Views
50
Replies
5
Views
174

1,127,847
Messages
5,627,239
Members
416,232
Latest member
Ash1432

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back