I have a basic formula as follows =L2+30 it's basically for calculating payment terms on invoices, based on 30 day terms.
However what I need help with is as follows:
If A2 equals "Abc Ltd" then the current formula of "L2+30" should be become "L2+60", but only if the text in A2 is ABC Ltd, otherwise it's plus 30.
I have tired but no luck.
Thank in advance for any help
Bookmarks