Search results

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...

Dear SirJB7, Thank you very much for your help.... Keep sharing your knowledge to the needy like us... regards Sanjay

i want to use ceiling function as per the number in the cell value. if cell value is below 10, ceiling, 0.10 if cell value is above 10, below 50, ceiling, 0.50 if cell value is below 50, ceiling, 1.0 is it possible?

I have sheet in which I have hidden my price calculation. I do not want any one else to know this calculation. Though, I have hidden and protected sheet, when I select the while sheet & copy into new sheet, it copies everything... How do I protect my calculation? please help...

Many thanks Fasseh... God bless you... Bye...

Dear Muneer thanks for your reply... but it is little different. Item Qty Price 1 2 3 4 5 6-10 11-15 &#62;=16 abc 10 43 100 80 70 65 58 43 39 32 pqr 4 63 98 78 68 63 55 40...

I have part number column & prices in columns based on quantity such as 1,2,3,4,5 6~10, 11~15 & &#62;=16 etc. i wish to have price appeared for exact quantity... for that part number... when I type qty in blank column, the right price for that quantity should appear in next blank column...