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

53 thoughts on “IF function

  1. air max 95

    Aw, this was a really nice post. In concept I would like to put in writing like this additionally ?taking time and actual effort to make an excellent article?but what can I say?I procrastinate alot and not at all appear to get something done.

Leave a Reply

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