Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
capping percents
ok here it is:
Base Goal Target Actual Gain or -Loss Point Quarterly 1.592% 0.09% 1.500% 0.092% 1.500% 100% 50 50 $294 lets say the "actual" exceeds the"goal" or put another way instead of 1.5 it may be 1.2, then i want the "gain or -loss" to cap at a certain percentage, like 200%. the way i have it calucated now is if it does exceed then depending on the number it may go to 387%. Can someone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
capping percents
Hi,
Seeing your formula would have helped but in general you use MIN to set a maximum value like this =min(your maximum value,your formula) Mike "gma" wrote: ok here it is: Base Goal Target Actual Gain or -Loss Point Quarterly 1.592% 0.09% 1.500% 0.092% 1.500% 100% 50 50 $294 lets say the "actual" exceeds the"goal" or put another way instead of 1.5 it may be 1.2, then i want the "gain or -loss" to cap at a certain percentage, like 200%. the way i have it calucated now is if it does exceed then depending on the number it may go to 387%. Can someone help me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
capping percents
thanks
"Mike H" wrote: Hi, Seeing your formula would have helped but in general you use MIN to set a maximum value like this =min(your maximum value,your formula) Mike "gma" wrote: ok here it is: Base Goal Target Actual Gain or -Loss Point Quarterly 1.592% 0.09% 1.500% 0.092% 1.500% 100% 50 50 $294 lets say the "actual" exceeds the"goal" or put another way instead of 1.5 it may be 1.2, then i want the "gain or -loss" to cap at a certain percentage, like 200%. the way i have it calucated now is if it does exceed then depending on the number it may go to 387%. Can someone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percents | Excel Discussion (Misc queries) | |||
Capping number of attendees that increase monthly | Excel Worksheet Functions | |||
Capping Letters in EXCEL | Excel Discussion (Misc queries) | |||
Percents and Text in one cell - need to add percents only | Excel Discussion (Misc queries) | |||
Capping results | Excel Discussion (Misc queries) |