Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2011, 02:48 PM
AndrewSE AndrewSE is offline Help with formula please. Windows XP Help with formula please. Office 2007
Novice
Help with formula please.
 
Join Date: Apr 2011
Posts: 1
AndrewSE is on a distinguished road
Default Help with formula please.

Hello I'm new to the forums and looking for a little help please



I'm trying to figure out a formula for the following.

Lets say I have 400 as the target number.

You get a score of 450, which is 89% for the target of 400.

Now lets say you get a score of 350 ... I'd want that to come out as 100% since it is lower then the target.

hope that makes sense... Thank you !
Reply With Quote
  #2  
Old 04-04-2011, 05:30 PM
Kaneto Kaneto is offline Help with formula please. Windows 7 Help with formula please. Office 2010 (Version 14.0)
Competent Performer
 
Join Date: Nov 2010
Posts: 136
Kaneto is on a distinguished road
Default

I would do it with an IF formula. If the score is in A1, then the formula would be:

=IF(A1<400,1,400/A1)

With this formula, if the score is less than 400 the cell will produce a 1 (or 100% if it's formatted to percentage). If the score is greater than 400, the cell will display 400/score (e.g. 400/450 = 0.888889 = 89%).

-SW
Reply With Quote
  #3  
Old 04-05-2011, 07:30 PM
macropod's Avatar
macropod macropod is offline Help with formula please. Windows 7 32bit Help with formula please. Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,925
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Hi Andrew,

I'd suggest:
=MIN(1,400/A1)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 04-05-2011, 08:50 PM
Kaneto Kaneto is offline Help with formula please. Windows 7 Help with formula please. Office 2010 (Version 14.0)
Competent Performer
 
Join Date: Nov 2010
Posts: 136
Kaneto is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Andrew,

I'd suggest:
=MIN(1,400/A1)
Even better. I knew there was an easier way to accomplish this but I just could not remember it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with formula please. PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
Help with formula please. Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Help with formula please. If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Help with formula please. Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM


All times are GMT -7. The time now is 12:00 PM.


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