IF function

Dear sir, I have Quarry   I Have Stock Item in Column A1 Cell Phone A2 Key Borad Key Borad 

Column B1 Amount Rs 10,000 

Columns B2 Amount Rs 5100

Column C1 Stock Item Cell Phone

Columns C2 Stock Item Key Boad

 Column D1 Amount Rs 10,500

Column D2 Amount Rs 3500

 Here I have used if(A=C2,B2-D2) Ans is 500 but if  drag the formula its not taking the formula reference so kindly give the solution

By: vemula satheesh

One thought on “IF function

Leave a Reply

Your email address will not be published. Required fields are marked *