SOLVED

How to do a formula for Cell with multiple values?

Copper Contributor

I need some help

I want my cell to be, option 1 or 2 is a "No Fee" if anything else I want it to be "Charge"

 

 

Here is my formula:

=IF(A1="Early (Inside Window)","No Fee",IF(A1="OnTime (Inside Window)","No fee"," Charge"))

My "OnTime (Inside Window)" is always Charge when I want it to be "No Fee".

 

Any and all help is much appreciated.

 

2 Replies
best response confirmed by cwatkins (Copper Contributor)
Solution

@cwatkins It appears to work for me as is. Are you sure the contents of A1 don't have trailing spaces, or perhaps some hidden special characters (sometimes happens when copy/pasting from other applications).

 

JMB17_0-1645205282801.png

 

Yes, Thank you. There was a missing character in the "OnTime (Inside Window" (The last parentheses was left out.) and it wasn't seeing it. You would think as many times I've looked over it I would've seen it. I guess I should've walked away for a bit.
Thank you again.
1 best response

Accepted Solutions
best response confirmed by cwatkins (Copper Contributor)
Solution

@cwatkins It appears to work for me as is. Are you sure the contents of A1 don't have trailing spaces, or perhaps some hidden special characters (sometimes happens when copy/pasting from other applications).

 

JMB17_0-1645205282801.png

 

View solution in original post