ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   help needed (https://www.excelbanter.com/excel-worksheet-functions/111937-help-needed.html)

cward1

help needed
 
Hi,

I have two columns in excel showing our company's pricing and our customer's pricing. Both columns should read the same but i want to add a formula that will show any differences.

any ideas?

thanks in advance.

Alan

help needed
 
With the two pricings in columns A and B, in C1 enter =ABS(A1-B1) and drag
it down to the end of the lists.
Regards,
Alan.
"cward1" wrote in message
...

Hi,

I have two columns in excel showing our company's pricing and our
customer's pricing. Both columns should read the same but i want to add
a formula that will show any differences.

any ideas?

thanks in advance.




--
cward1





All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com