Forum Discussion

BlueMoose's avatar
BlueMoose
Brass Contributor
Jun 26, 2023
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 27, 2023

    BlueMoose 

    As variant

    =IF( D4= "", "", 600 + 1759*(D4<>0) )
BlueMoose's avatar
BlueMoose
Brass Contributor
Jun 27, 2023
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).
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 27, 2023

BlueMoose 

As variant

=IF( D4= "", "", 600 + 1759*(D4<>0) )
  • BlueMoose's avatar
    BlueMoose
    Brass Contributor
    Jun 27, 2023
    Perfect! That did it exactly.

Resources