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

Text to columns wizard in Excel

"Delimited" means you want to break up the column based on characters such as commas, spaces, or tabs. "Fixed Width" means you want to select the exact location on all the columns that you want the split to occur.

Lynil Thomas

0 0

SQL (Structured Query Language)

SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...

ITech Analytic Solutions

0 0

Lookup Reference Formulas

MS Excel Formulas - Lookup Reference Formulas

Shashank Maheshwari

0 0

Most important things to remember while doing VLOOKUP! (Donts..)

Make sure there are no unwanted or additional spaces in between the words or afterwards Example: Robert Smith_ Note: To show the additional spaces I have underlined the entire words. Don’t...

Shylaja M.

0 0

Dynamic HyerText Markup Language (DHTML)

Dynamic HyerText Markup Language (DHTML) is a combination of Web development technologies used to create dynamically changing websites. Web pages may include animation, dynamic menus and text effects....

ITech Analytic Solutions

1 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

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

7 Answers

Do u know Power Pivot Deeply ? If Yes, Kindly reply... Regards

26 Answers

What is VBA and what is its importance?

5 Answers

How to write square in excel?

9 Answers

How do I delete a worksheet in MS Excel?

14 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

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.