Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
on my excel sheet: =k26*2.2046*4.55/100
if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? i could swear i have done it before! please help! thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
thejellybean66 wrote...
on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
"Harlan Grove" wrote: thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? thanks for your reply!!!!! I put in the formula in the wrong cell and i should have clicked YES for if you answered my question! Sorry about that and thank you again! this was driving me insane! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
"Harlan Grove" wrote: thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? sorry, i forgot to include another one in my original post... one cell i have: =k20*r24 if this is less than 10 i need it to state 10 and if it is greater than 10, i need it to state that number. thank you. :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
"thejellybean66" wrote in message
... "Harlan Grove" wrote: thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? sorry, i forgot to include another one in my original post... one cell i have: =k20*r24 if this is less than 10 i need it to state 10 and if it is greater than 10, i need it to state that number. thank you. :) The suggestions for your previous question were MIN and MAX. Why not look at the help for those functions, and work out which one you need for your new question? -- David Biddulph |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
"Harlan Grove" wrote in message
oups.com... thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? ... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? Or another option is =MEDIAN(88,480,K26*2.2046*4.55/100) -- David Biddulph |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
maybe
=max(10,k20*r24) -- ***** birds of the same feather flock together.. "thejellybean66" wrote: "Harlan Grove" wrote: thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? sorry, i forgot to include another one in my original post... one cell i have: =k20*r24 if this is less than 10 i need it to state 10 and if it is greater than 10, i need it to state that number. thank you. :) |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with functions
Thank you!!!
for some reason, i just couldn't follow the steps from excel "help" to figure it out...i was up early yesterday and up real late...maybe i was just a bit punchy? thanks again! "driller" wrote: maybe =max(10,k20*r24) -- ***** birds of the same feather flock together.. "thejellybean66" wrote: "Harlan Grove" wrote: thejellybean66 wrote... on my excel sheet: =k26*2.2046*4.55/100 if the number in this cell is less than 88, I need it to show 88.00 min and if it is over 480, i need it to show 480.00 max. also, if the number is in between 88.00 and 480.00, i need it to state that number. is this possible? .... Do you mean =MAX(88,MIN(480,K26*2.2046*4.55/100)) ? sorry, i forgot to include another one in my original post... one cell i have: =k20*r24 if this is less than 10 i need it to state 10 and if it is greater than 10, i need it to state that number. thank you. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advantage of Database functions | Excel Worksheet Functions | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions |