Forum Discussion

DavidWhitcher's avatar
DavidWhitcher
Copper Contributor
May 03, 2022
Solved

Adding IF cells.

Hi all.  I have a column using an IF formula to create a value. I then want to add those values; however, as they are not numbers (even though the cell is formatted as such), I cannot get them to au...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 03, 2022

    DavidWhitcher 

    Just use numbers in source formulae, not texts. Like

    =IF(D2=M$2,0, IF(D2=M$3, 5,IF(D2=M$4,10,IF(D2=M$5,15))))

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 03, 2022

DavidWhitcher 

Just use numbers in source formulae, not texts. Like

=IF(D2=M$2,0, IF(D2=M$3, 5,IF(D2=M$4,10,IF(D2=M$5,15))))

 

  • DavidWhitcher's avatar
    DavidWhitcher
    Copper Contributor
    May 03, 2022

    SergeiBaklan

    Perfect. Thank you. I put the quotation marks in to produce the result. Now they're removed, it works a treat.

    Many thanks

    Dave