Hi all,
I've been trying for a couple of hours on this one and can't seem to add a condition to an IF Statement.
The below is a working formula:
=IF(A2="COR","TRADE",IF(L2>10,"TRADE","B2C"))
What I'd like to do is add a condition eg =IF(OR(A2="cor","trade",A2="2NA", "B2C",IF(L2>10,"TRADE","B2C"))
But it doesn't seem to like me adding 'OR' A2="2NA", "B2C" as a second condition.
Any help would be fab.
Thanks
Mark
This:
=IF(A2="cor","trade",IF(A2="2NA", "B2C",IF(L2>10,"TRADE","B2C")))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi thanks but i receive this message 'The formula is missing an opening or closing parenthesis'
Last edited by AliGW; 04-09-2021 at 06:49 AM. Reason: PLEASE don't quote unnecessarily!
Did you copy it correctly? There should be three ( and three ).
Attach the workbook if you can't work it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks