excel if command

July 21, 2010 at 03:36:08
Specs: Windows Vista
Can someone correct the following if command IF(D2:CU12=1,IF(D2:CU12,">18"),1)

See More: excel if command

Report •

July 21, 2010 at 06:47:09
You haven't said what you are trying to achieve.

The formula you posted doesn't show any options - basically you appear to be trying to return the value 1 if the SUM of the cells in the range D2 to CU12 equals 1
you also seem to want to return 1 if those same cells add up to greater than 18.

What do you want to return if neither of those conditions is met?

I suggest you post what you want to do - in words:
For example - If the sum of the cells D2 to CU12 is 1 then return 1; If the sum is >18 then return 1, but if the sum is less than 1 or between 2 and 18 return the sum of these cells.


Report •
Related Solutions

Ask Question