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%
1 Reply
- mtarlerSilver Contributortry this
=IF(G1>=1,D1*C1,D1)