Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas with percentages | Excel Discussion (Misc queries) | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |