Thread
:
enter if less than
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
Posts: 11,501
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 With Quote
Mike H
View Public Profile
Find all posts by Mike H