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
|