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