true

Learn Microsoft Excel Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Basic EXCEL Tips

Kshitij Agrawal

08/11/2016 0 0

Learn Use of MAX function in EXCEL:

Penalty of Rs. 2% or Minimum Rs. 100

Amount	Penalty	Formula
Rs 1000	200	+MAX(1000*2%,100)
Rs 400	100	+MAX(400*2%,100)

0 Like 0 Dislike

Follow 0

Other Lessons for You

Hidden Gems of MS Excel - Find Unique Records using Advance Filter

Want to find UNIQUE Values in a Dataset/Range? By using an Option that is Flexible and Quick. You should find the Advance Filter option helpful. Q) But, Advance Filter is used for filter-ing?A)...

Ankur Sharma

1 0

What is Microsoft Access?

Microsoft Access has been around for some time, yet people often still ask me what is Microsoft Access and what does it do? Microsoft Access is a part of the Microsoft Office Suite. It does not come with...

Itech Analytic Solutions

0 0

Clipboard Task Pane

When you copy a cell's contents, formula or format, that information goes into the clipboard. The clipboard will hold the information until you decide to paste it somewhere else on the spreadsheet,...

Saburudeen Ma

0 0

HTML (Hypertext Markup Language)

HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

Itech Analytic Solutions

1 0

VBA Tip: Print Random Numbers In A Selected Range

Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

How to use the h look up in excel worksheet ???

24 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 Answers

Are there any VBA tutors around Secunderabad?

11 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.