If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|