In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

It's taken since 1:00 am to figure it out (only 8+ hours) but I did get it to
work - could there have been an easier way? I used:

=IF(OR(D2=TODAY(),E2=D2)," ","Y")



"bj" wrote:

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

What are you trying to do?
this equation gives Y for false and "" for true

"Lisa" wrote:

It's taken since 1:00 am to figure it out (only 8+ hours) but I did get it to
work - could there have been an easier way? I used:

=IF(OR(D2=TODAY(),E2=D2)," ","Y")



"bj" wrote:

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

Hi BJ,

Yes, exactly what I needed. I'm trying to track purchase orders. If the
order
"Date ordered"
PO #
Item description
"Date expected"
"Date Received"
F/U - FOLLOW UP GIVES A 'YES' OR STAYS BLANK depending on if the order was
received or not.
"F/U date"
"New expected date"
F/U - SAME HERE - FOLLOW UP GIVES A 'YES' OR STAYS BLANK

"bj" wrote:

What are you trying to do?
this equation gives Y for false and "" for true

"Lisa" wrote:

It's taken since 1:00 am to figure it out (only 8+ hours) but I did get it to
work - could there have been an easier way? I used:

=IF(OR(D2=TODAY(),E2=D2)," ","Y")



"bj" wrote:

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.

As a question,
If the item got there before it was expected, you would have a f/u as yes
if the date received cell is empty until item is received, You might try

=if(and(D2=Today(),E2=""),"","yes")

"Lisa" wrote:

Hi BJ,

Yes, exactly what I needed. I'm trying to track purchase orders. If the
order
"Date ordered"
PO #
Item description
"Date expected"
"Date Received"
F/U - FOLLOW UP GIVES A 'YES' OR STAYS BLANK depending on if the order was
received or not.
"F/U date"
"New expected date"
F/U - SAME HERE - FOLLOW UP GIVES A 'YES' OR STAYS BLANK

"bj" wrote:

What are you trying to do?
this equation gives Y for false and "" for true

"Lisa" wrote:

It's taken since 1:00 am to figure it out (only 8+ hours) but I did get it to
work - could there have been an easier way? I used:

=IF(OR(D2=TODAY(),E2=D2)," ","Y")



"bj" wrote:

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.