Hi everyone,
On the example file attached I am looking to create an IF statement, or a method that gets the same result, that does the following:
Formula in cell D2: if A2 is "In production", "despatched" or "delivered" then return the number in column B2, but if not one of these statuses then formulate =(B2/100)*C2
Another method I may look at is the following:
Formula in cell D2: formulate =(B2/100)*C2, if C2 is blank then assume its 100.
If I have not explained anything fully please let me know and I will elaborate.
Thanks for your help in advance.
Bookmarks