Write a formula for a penalty for status of TRUE?

[Esperanza]

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

 

[Bob Phillips]

Do you mean something like

=IF(A2=TRUE,50,0)

HTH

Bob

 

[Fred Smith]

Assuming "$)" means "$0", try:
=if(a1="TRUE",50,0)

Adjust the range to suit.

Regards,
Fred

 

[David Biddulph]

But you need to be careful as to whether it is a text string, or the boolean
value TRUE.
The double quotes make a difference.

 

[Fred Smith]

I know. That's why I proposed this solution. Given the skill level of the
OP, I believe he's looking for "TRUE" rather than TRUE.

Regards,
Fred