Editing excel is fast and straightforward using DocHub. Skip installing software to your PC and make alterations with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competitive cost, makes DocHub the perfect decision to vary expense in excel files with ease.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the protection of your information, as we securely store them in the DocHub cloud.
welcome back to new video tutorial in Microsoft Excel and in this video we are going to learn how to calculate the value of the products with multiple pricing condition and here you can see example where there are different products name given and there is a category wise price for example if a customer purchases the product which is between 1 to 100 case then this price will be applicable similarly if the customer purchase the product which is 101 case to 200 case then the second price will be applicable similarly for 201 to 300 case this price will be applicable and for 301 and a book here I am writing this 301 and above in this case this this price will be applicable so when we put quantity here because this quantity is variable up to every customer when we change the quantity here in that case these quantity should be multiplied with the appropriate price to calculate the right value for example here the quantity is given as 20 so this is this comes under the category of 1 to 100 c
