Forum Discussion
Solved
IFS Regarding Specific and Broad Values
I'm trying to find a way to say that if D4 shows as 0000 then if should add 600; but, for all other values other than that, it should show as 2359. I did =if(D4,2359,"") but realised that left me in the predicament for the lone value where I need the 600 added.
BlueMoose Taking your description literally, I take it that you are dealing with text strings. Otherwise you would not mention that D4 could contain 0000. Perhaps this does what you need:
=IF(D4="0000",D4&"600","2359")
This will return text strings "0000600" or "2359".
Though, if you are dealing with numbers try this:
=IF(D4=0,600,2359)
- Riny_van_Eekelen I definitely wasn't clear enough in my message. I'm dealing with numbers; but also want the cell to appear empty if D4 is empty. This will be in cell E4 which either appear empty (if D4 is empty), have 600 (if D4 has 0) or 2359 (if D4 has anything other than 0).
