Forum Discussion
Rich_Kalin
Jul 29, 2020Copper Contributor
If Function. Want to say if a cell is 100% or more then the bonus $ should be X.
I want to be able to create in cell H and and say if cell G is 100% to goal or larger , then multiple cell D by cell C Example: Cell G is 101% Cell D is $979,000 Cell C is 2%
mtarler
Jul 29, 2020Silver Contributor
try this
=IF(G1>=1,D1*C1,D1)
=IF(G1>=1,D1*C1,D1)