Solved, thanks
Solved, thanks
Last edited by jochefgo; 07-04-2020 at 03:18 PM.
@jochefgo
Welcome to the excel forum.
With VLookup
Make a Vlookup table in column F and G
C2=A2*VLOOKUP(A2,$F$2:$G$7,2,1)+B2 and drag down.Please Login or Register to view this content.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Without looking up table. Although I also prefer that.
Thank you both so much, I now have my correct formula. Much appreciated!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks