Home

Excel formula help

Highlighted
august22
Occasional Visitor

Hello, I am learning as I go a Excel. I hope you all can help me, as this is out of my range of understanding and not sure if this is possible or where to start.  Here is an example of my data in Excel.

 

Capture.PNGex.PNG

 

I am checking for accuracy here. Column C contains receipt numbers.  E:8 for example has a numeric value of 10 and is highlighted in green and is associated with receipt 337068.  Basically how this works is I have to take each receipt number and add the values associated with it then add $17.22. This must equal the new act plan payment also highlighted in green. In this case we have 10 + 17.22 must equal the new activation plan payment of $27.22. In this case it does and this receipt is good. Moving down to 337290. As you can see this one has an add on of $6. So we have E16 + E18 + $17.22 must equal G19 (6+50+$17.22 must equal $73.22. And again in this case it does, so I need nothing. What I am wondering is if there is a way to have the program return to me the receipt numbers of the ones that DO NOT equal. This is something I do for the company and can be very time consuming. Any help would be greatly appreciated. Thanks

 

 

 

 

 

 

 

 

 

1 Reply
I suggest that you modify the layout of your data so that each column contains only one type of data. For example, your column labels might be Receipt Number, Plan Type, Plan Description, Handset Price, Activation Price, Markup, and Total.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies