Forum Discussion

_Milena_'s avatar
_Milena_
Copper Contributor
Jun 06, 2019
Solved

Excel formula help

Hi everybody!   Although i have been using Excel every day, the time has come today to realise i know nothing about formulas :) I'm struggling to make the attached calculator works as follows: - ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 06, 2019

_Milena_ , perhaps

=MAX(10,MAX(B19,B20*1000)*0.01)
_Milena_'s avatar
_Milena_
Copper Contributor
Jun 06, 2019

SergeiBaklan ,

 

Thank you so much :)

    • _Milena_'s avatar
      _Milena_
      Copper Contributor
      Sep 12, 2019

      Hi all,

       

      Something went wrong with my calculator 😞

      I have been using =MAX(8/13,MAX(B25,B26*1000)*0.023) 

      But i have just noticed that even when B25 and B26 are blank, there is still a value in B29

       

      Can anyone help me please

       

      Thank you

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 12, 2019

        _Milena_ 

        It returns 8/13 in such case. If you'd like to have zero if both B25 and B26 are empty, when like

        =MAX(8/13,MAX(B25,B26*1000)*0.023)*(B25<>0)*(B26<>0)

         

Resources