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

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

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

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

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