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

%3CLINGO-SUB%20id%3D%22lingo-sub-1554059%22%20slang%3D%22en-US%22%3EIf%20Function.%20Want%20to%20say%20if%20a%20cell%20is%20100%25%20or%20more%20then%20the%20bonus%20%24%20should%20be%20X.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554059%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20be%20able%20to%20create%20in%20cell%20H%20and%20and%20say%20if%20cell%20G%20is%20100%25%20to%20goal%20or%20larger%20%2C%20then%20multiple%20cell%20D%20by%20cell%20C%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3ECell%20G%20is%20101%25%3C%2FP%3E%3CP%3ECell%20D%20is%20%24979%2C000%3C%2FP%3E%3CP%3ECell%20C%20is%202%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1554059%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554073%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Function.%20Want%20to%20say%20if%20a%20cell%20is%20100%25%20or%20more%20then%20the%20bonus%20%24%20should%20be%20X.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554073%22%20slang%3D%22en-US%22%3Etry%20this%3CBR%20%2F%3E%3DIF(G1%26gt%3B%3D1%2CD1*C1%2CD1)%3C%2FLINGO-BODY%3E
New 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