Write a formula for a penalty for status of TRUE?
 

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

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

Write a formula for a penalty for status of TRUE?
 

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

Adjust the range to suit.

Regards,
Fred

"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

Write a formula for a penalty for status of TRUE?
 

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.
--
David Biddulph

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

Adjust the range to suit.

Regards,
Fred

"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

Write a formula for a penalty for status of TRUE?
 

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

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

Adjust the range to suit.

Regards,
Fred

"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