Recent content by smisar

Hello Mr. Bosco, I have one more small issue to be solved. When F1 is lower than MOQ (B51), then I want to have 220 (B51) as answer in G1. Then apply wild card formula considering G1 and get price. Please help...

HELLO BOSCO, I HAVE ONE MORE SMALL ISSUE TO BE SOLVED. WHEN F1 IS LOWER THAN MOQ (B51), THEN I WANT TO HAVE 220 (B51) AS ANSWER IN G1. THEN APPLY WILD CARD FORMULA CONSIDERING G1 AND GET PRICE... PLEASE HELP...

I have attached a sheet which has around 395 rows of items and three columns. When I am making a new invoice or quote, in other sheet, I want to just click the check box in column no 1, the checked items appear in my other invoice or quote sheet, with description, quantity and price... I hope I...

Thanks Bosco... I will try this... if need more help, I will revert...

Hello Bosco, Good Morning... IS have one more small question... I have added short description column C... If I type AS-048 in C4, is it possible to have full description in D4?

Great & Thanks, Bosco... I used it correctly... it works...

Hello Bosco, Thanks. It works well... Now I have one more small request... When I am filling the data in description to get pricing Say "AS568-041 (90.92 x 1.78) V9000AA, when I start typing AS568-041, is it possible that rest of the description gets automatically filled in to avoid mistake...

Hello... I have two price lists for the same items. Price as per sheet A and B. On first page, if I select price list type A and fill the description, then the price column should refer & get correct price according to price list type and quantity. Please refer sample sheet for your ease of...

Thanks Khalid... I think Bosco's solution is working for me... regards... Sanjay

Thanks Bosco... It works perfectly... If in any problem, will get back to you... best regards Sanjay...

Thank you for your help... There is some problem in the formula... If you apply this to rows 375, 376 377 then the results are not correct. Please check the same and suggest correction.

This not correct I feel. I have more than 700 such line items. I need a unique formula to copy to all quantity cells to get right price for quantity mentioned in B2... Please help me...

I have MOQ and Price dadabase as above. I want excel to choose right price for MOQ entered in quantity column. if MOQ>=6000 but <21000, price 0.26 if MOQ>=21000 but <48000, price 0.24 if MOQ>=48000, price 0.21 Please suggest suitable formula... Please help me... regards Sanjay Misar

I have an excel sheet on which I made some pricing calculations. Say I made a price calculator in which price appears in a cell based on quantity input. This works well with hide and protect... Now when I copy this protected entire sheet and paste into new sheet, all info is revealed.. can...