ArrrgggHHHH! I can't workout where wrong!

=IF(B1=“WALL”,0,1+IF(VARIED_HEIGHT=“NO”,0,1+IF(VARIED_WIDTH=“NO”,0,1)))

I’m trying to get a number! What am I doing wrong, I’m having a seriously dumb moment!

To get a one added if any false

=IF(b1="WALL",0,1)+IF(varied_height="NO",0,1)+IF(varied_width="NO",0,1)

however a DC example and what you expect may help, as the result does not distinguish between which triggers an addition

1 Like

That worked a treat! Mind you I’m sure I tried it! I had closed file and re-opened before putting in your solution, I wonder if that may have somehow ‘refreshed’ the workspace?

I needed either 0,1 or 2. it now resolves correctly!!! Thanks again Phil!