Can someone correct the following if command IF(D2:CU12=1,IF(D2:CU12,">18"),1)

Hi,

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

but

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.Regards

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History