I have this formula in my excel spreadsheet - =IF(OR(AJ14="FALSE",AJ14=""),"",IF(AND(AJ14="TRUE",K14="In-State"),"7.50","13.00")) - but no matter what, it keeps returning $13.00. I have verified that K14 is truly 'In-State' but still I'm not getting the right response. I'm assuming that there is just something in my formula that is causing me this grief. :shocked: Please help!! Any help will be greatly appreciated!!
Can someone help me with a formula?
- Thread starter KristenB
- Start date
AliGW
Administrator
- Joined
- Nov 8, 2015
- Messages
- 1,843
- Reaction score
- 8
- Points
- 38
- Location
- Ipswich, Suffolk, England
- Excel Version(s)
- MS 365 (Beta Insider Channel)
Please attach your workbook so that we can troubleshoot it for you.
Pecoflyer
Admin Alumnus
- Joined
- Oct 13, 2011
- Messages
- 1,802
- Reaction score
- 1
- Points
- 38
- Location
- Brussels Belgium
- Excel Version(s)
- 2010 on Xubuntu - O365
I think you need to remove the double quotes around FALSE and TRUE
That fixed my issue completely!! Thank you so much for your help!! Please tell me how to give you a gold star!Thank you for looking at this, AliGW,however, Pecoflyer had a suggestion and I tried it and that fixed my issue. This is one of those 'duh' moments in my life. LOL I appreciate that you were also ready to offer assistance. Thank you!
Last edited: