Forum Discussion

HadInc9797's avatar
HadInc9797
Copper Contributor
May 04, 2020
Solved

Tables Question

If I have a table that I want some rows to include a 10% markup but other rows not, is there a formula that is able to help me determine this? Basically I have a Yes or No column currently, and what ...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    May 05, 2020

    HadInc9797 

    That would be:

    =([@[10% Markup]]="Yes")*[@[Unit Cost]]*0.1
Khizar_Hayat's avatar
Khizar_Hayat
Brass Contributor
May 04, 2020

it can be done by using if function, if you have a sample file share to us, may be best solution will be occured HadInc9797 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 05, 2020

    HadInc9797 

    That would be:

    =([@[10% Markup]]="Yes")*[@[Unit Cost]]*0.1
    • HadInc9797's avatar
      HadInc9797
      Copper Contributor
      May 05, 2020

      Detlef_Lewin Thank you so much!! It worked!!

Resources