Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - If Statement - Excel

2002 excel microsoft training - If Statement - Excel

ResolvedVersion Standard

Mon 24 Sep 2007, 15:35 Delegate Dan said...

Dan has attended:
No courses

If Statement - Excel

Hi All

Im currently working on a spreadsheet whereby i need to know if Cell BK10 is between 2500-3499 the figure that it is above 2500 by needs to be multiplied by 0.45 BUT at the same time i need to incorporate into the formula that if it is also above 3500 and by how much then that figure needs to be multiplied by 0.60

So if the figure is 3800
then 999 needs to be multiplied by 0.45

and

300 needs to be multipled by 0.60

Then both of the figures need to be added together.

Please can you help me put together the correct formula so that this can be worked out

Than you

Dan

Tue 25 Sep 2007, 10:44 Delegate Paul said...

RE: If Statement - Excel

Hi Dan,

Try this (untested)

=IF(AND(BK10>2500,BK10<3500),(BK10-2500)*0.45,IF(BK10>=3500,(BK10-3499)*0.6,""))

it will probably need a bit of tinkering with the figures but that'll probably work..

Hope this helps

Paul

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

2002 excel microsoft training - If Statement - Excel

If Statement - Excel

RE: If Statement - Excel

Excel articles

Excel tip:

Autonumber in Excel