Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-12-2012, 12:09 PM
GoldenSlumbers GoldenSlumbers is offline Help with excel formula Windows XP Help with excel formula Office 2003
Novice
Help with excel formula
 
Join Date: Dec 2012
Posts: 8
GoldenSlumbers is on a distinguished road
Default Help with excel formula

Hi I need to make a spreadsheet with the following inputs.

1-Volume -%
2-Volume target -%
3-Profit -£
4-Profit target -£
5-Contract - 1/0

If 1-Volume is greater than or equal to 2-Volume Target AND 3-Profit is greater than or equal to 4-Profit Target OUTPUT 3-Profit MINUS 4-Profit target MULTIPLIED by 0.4

If both of them are not 100% or more then it's 10% (*.1) unless 5-Contract =1, then it's (*.2)

I hope this makes sense and you can give me some help and ideas.

Thanks
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with excel formula Excel Formula oRie Excel 2 02-28-2012 07:48 PM
Help with excel formula ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Excel Formula Help masoom84 Excel 1 03-07-2009 09:41 AM
Help with excel formula Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft