enter if less than

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tisaman - 06 Feb 2008 20:50 GMT

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 to this Message

FSt1 - 06 Feb 2008 20:58 GMT

hi,
first, i don't see 2 cells. ???
anyway based on what you did wrote after that.....

=if(G98*3>30,30,G98*3)

regards
FSt1

> i am trying to get the sum of two cells or $30, whichever is less
>
[quoted text clipped - 6 lines]
>
> thanks

Reply to this Message

tisaman - 06 Feb 2008 21:06 GMT

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

> hi,
> first, i don't see 2 cells. ???
[quoted text clipped - 15 lines]
> >
> > thanks

Reply to this Message

Gary''s Student - 06 Feb 2008 20:59 GMT

=IF(3*G38>30,30,3*G38)

Signature

Gary''s Student - gsnu200767

> i am trying to get the sum of two cells or $30, whichever is less
>
[quoted text clipped - 6 lines]
>
> thanks

Reply to this Message

Mike H - 06 Feb 2008 21:10 GMT

Another

=MIN(G38*3,30)

Mike

> i am trying to get the sum of two cells or $30, whichever is less
>
[quoted text clipped - 6 lines]
>
> thanks

Reply to this Message