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