Hi, my Name is Nabeel Esrawi, I am in the automotive business, I use Excel 5 days a week. I joined your forum to help me with some formulas.
Hi, my Name is Nabeel Esrawi, I am in the automotive business, I use Excel 5 days a week. I joined your forum to help me with some formulas.
Hello nesrawi,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you I have a questions though, can you help me with creating between Formula?
looking forward to your expert advise
Hello GC , thanks for the vlookup, however it did not work, what I meant is as follows
ROW 38 is the total of units and row u38 is total commissions, therefore if row r38 is less than 0.5 or over 9 then i need row u38 to show 0, and then if row r38 is between 0.5 and 8.5 then row 38 shows the total amount.
Thanks
Please see red arrows.jpg
Hello again GC please see red arrows on the attachement
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks