Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - If Statement - Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
2002 excel microsoft training - If Statement - Excel
Resolved · Low Priority · Version Standard
Reply Mon 24 Sep 2007, 15:35Delegate 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
For upcoming training course dates see: Pricing & availability
Reply Tue 25 Sep 2007, 10:44Delegate 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
|