Search results

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

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

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

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

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