If Function. Want to say if a cell is 100% or more then the bonus $ should be X.

Copper Contributor

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