Formulas with percentages
 

Maybe someone can help me with this...If a person sold something last year
for let's say $100 and this year they upsell them to $125, then they sold 25%
more than last year...ok. So if they get point for upselling 25% or more then
what formula would I use to make that happen?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

Hi

Hope I understood the problem!

In A1 you put last year's sales
In B1 you put this year's
In C1 you put =IF(B1<=A1*1.25,"Point","No Point")

HTH


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=392211

HMMM....I ALREADY HAVE THE C1 INFO SO HOW WOULD THE FORMULA CHANGE NOW? AND
ANOTHER QUESTION I HAVE IS ABOUT THE "POINT"....WOULD THAT BE 1 FOR POINT AND
0 FOR NO POINT...SO IT WOULD I CHANGE IT TO LOOK LIKE THIS?

=IF(C1*1.25,"1","0")

Colin Vicary wrote:
Hi

Hope I understood the problem!

In A1 you put last year's sales
In B1 you put this year's
In C1 you put =IF(B1<=A1*1.25,"Point","No Point")

HTH



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1

The IF function needs a logical test which can be answered TRUE or
FALSE.

For example =IF(A1B1,A1,B1)

This would check to see if A1 is greater than B1 (A1B1)

If it is, the result would be A1, if not the result would be B1

It may be better described by =IF(do the comparison, value if true,
value if false)

In your example, you are not asking IF to do anything, you would need
to change it to something like =IF(c1=100,1,2) The quotes are only
needed if the output is text.

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=392211