Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested if functions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Nested if functions

Resolved · Urgent Priority · Version 2007

Reply Fri 18 Nov 2011, 12:28Delegate Gurdeep said...

Gurdeep has attended:
Excel Advanced course

Nested if functions

Can anyone help

I am attempting to build a salary spreadsheet..

I have the following columns..

Months worked gross salary Q1 Q2 Q3 Q4
a b c d e f

if someone works for only 4 months of the year then i apply a formula

=if(a<3,b/12*a,b/12*3)

then for the Q2 formula if someone staggers a quarter ie works only 4 months then
if a>3 <6, a/12*6- (sum in previous formula to give Q2 amount) and so on...but it doesnt seem to work..
Can someone help?

Thanks

Gurdeep

For upcoming training course dates see: Pricing & availability

Reply Sun 20 Nov 2011, 11:43Trainer Rodney said...

RE: nested if functions

Hello Gurdeep,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding nested if functions.

Please send a copy of your file to me at:

rl

I will take a look at what it is you are trying to do and will give you the best possible solution. It will help if you explain why you want to perform these calculations. It will help me to produce the best solution.

Until then...

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Excel articles

· Securing Critical Company Information With Simple Visual Basic Training Courses
· How to Create Better Excel Spreadsheets: Part Three
· Creating Charts with Excel
· Going Against The Grain With Multiple Radio Buttons In Excel
· A Blinking Good Excel Tip

Please browse our web site to find out more about
vba excel course london and other Microsoft training courses.

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips