Sorry if I do not explain this well....
I am completing some spreadsheets and would like to highlight variances which are more that +or-5% and greater than +or- £500.
I have managed to do this using the following: (this may not be the easiest way but is working)
However this will only bring back TRUE or FALSE, I would like to have an option as to what the true or false value is. As I would in an IF statement.
I have tried to combine the above with an IF statement but this has not worked.
Any advice would be much appreciated