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 think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History