Thread
:
Max Value of a cell
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Toppers
external usenet poster
Posts: 4,339
Max Value of a cell
Change MAX to MIN
"cwilliams" wrote:
I entered that formula and it is not calculating if the value is under 1000
only if it is over 1000. Maybe the 1000 is in the wrong place?
=IF(I19="yes",MAX(1000,D15/52*0.6),0)
Reply With Quote
Toppers
View Public Profile
Find all posts by Toppers