Hopefully a straight forward one for you guys but please can someone help!
I want to do the following;
If column A has "Standard" and the date in Column B is below a chosen date then do one calculation. If column B has a date higher than the chosen date then do a different calculation. However if column A does not have "standard" then use the original calculation regardless of date.
I have tried an IF OR formula but it ignores one criteria and produces the wrong calculation for some of the dates.
I have tried an IF AND formula and this works while the column has "standard" in it, but when this is removed it does not work.
Please help!
I want to do the following;
If column A has "Standard" and the date in Column B is below a chosen date then do one calculation. If column B has a date higher than the chosen date then do a different calculation. However if column A does not have "standard" then use the original calculation regardless of date.
I have tried an IF OR formula but it ignores one criteria and produces the wrong calculation for some of the dates.
I have tried an IF AND formula and this works while the column has "standard" in it, but when this is removed it does not work.
Please help!