2002 excel microsoft training - if statement excel

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

resolvedResolved · Low Priority · Version Standard

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

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:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips


Server loaded in 0.09 secs.