• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto calculation formula help

B

bharath

Member
Hi All,

I could not explain properly by writing that, what i want exactly, So i attached the excel file

thank you
 

Attachments

  • TASK BHARATH.xlsx
    22.5 KB · Views: 11
In O2, formula copied right :

=ROUND(VLOOKUP($N2,$B:$D,(RIGHT(O$1)="N")+2,0)/VLOOKUP($K2,$B:$D,(RIGHT(O$1)="N")+2,0)*L2,0)

76871
 
You must log in or register to reply here.
Back
Top