V
VT - Maryland
I need formula for commission of 25% if cell c22 is greater than $2,600. and
less than $4,499. I keep trying =IF(C22>4500,"0",IF(C22<2600,"c22*25%"))
with a value in cell c22 of $4,500, but I get the result of FALSE instead of
zero.
less than $4,499. I keep trying =IF(C22>4500,"0",IF(C22<2600,"c22*25%"))
with a value in cell c22 of $4,500, but I get the result of FALSE instead of
zero.