| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter if less than
i am trying to get the sum of two cells or $30, whichever is less
g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3 can anyone help me? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
enter if less than
hi,
first, i don't see 2 cells. ??? anyway based on what you did wrote after that..... =if(G98*330,30,G98*3) regards FSt1 "tisaman" wrote: i am trying to get the sum of two cells or $30, whichever is less g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3 can anyone help me? thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
enter if less than
=IF(3*G3830,30,3*G38)
-- Gary''s Student - gsnu200767 "tisaman" wrote: i am trying to get the sum of two cells or $30, whichever is less g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3 can anyone help me? thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
enter if less than
perfect, perfect, perfect
it worked i can't believe i had a response in less than 2 minutes to my question i just found this group and i am luving it already you were right there is only one cell thanks again "FSt1" wrote: hi, first, i don't see 2 cells. ??? anyway based on what you did wrote after that..... =if(G98*330,30,G98*3) regards FSt1 "tisaman" wrote: i am trying to get the sum of two cells or $30, whichever is less g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3 can anyone help me? thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
enter if less than
Another
=MIN(G38*3,30) Mike "tisaman" wrote: i am trying to get the sum of two cells or $30, whichever is less g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3 can anyone help me? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Linear Mode
