Write a formula for a penalty for status of TRUE?
Do you mean something like
=IF(A2=TRUE,50,0)
HTH
Bob
"Esperanza" wrote in message
...
Need to write a formula in column H for a penalty of $50 for the customer
that has a fixed penalty status of TRUE and $) for all others
|