View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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