Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Function Will Get Me The Result I Need
Column A B C D
Row 1 4 5 =A/B 2 5 10 =A/B 3 10 6 =A/B 4 8 12 =A/B I have values entered in columns A and B. Column C is a percentage of those values. In column D I need to know a function so that if D is 100% or over it will equal 100% and if it is under 100% it will equal the value in C. What function should I use in column D to get me this result? From the above example column C will equal 80%, 50%, 167%, 67% I need the function for column D so the D will equal 80%, 50%, 100% 67% I never what the value of column D to be greater than 100% Hopefully I have explained what exactly I'm looking for. Thank you for your time in helping me with is. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Function Will Get Me The Result I Need
Disregard my question. I just got it with the IF function. I'm not quite sure why it was not working before.
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Function Will Get Me The Result I Need
wrote:
From the above example column C will equal 80%, 50%, 167%, 67% I need the function for column D so the D will equal 80%, 50%, 100% 67% I never what the value of column D to be greater than 100% =MAX(1,C1) formatted as Percentage. Note that 80% is 0.80, and 167% is 1.67. So 1.00 is 100%. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Function Will Get Me The Result I Need
Errata:
"joeu2004" wrote in message ... wrote: From the above example column C will equal 80%, 50%, 167%, 67% I need the function for column D so the D will equal 80%, 50%, 100% 67% I never what the value of column D to be greater than 100% =MAX(1,C1) Aarrgghh! I meant: =MIN(1,C1). Always my left and right mixed up, too. Klunk! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large function result as reference for offset function | Excel Discussion (Misc queries) | |||
IF function returns function statement rather than result | Excel Worksheet Functions | |||
I want result of a function in the cell and not the function itsel | Excel Worksheet Functions | |||
A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
Excel - saving result of a function without showing the function | Excel Programming |