I need to get a formula or formatting for:
I have data which is calculated from one sheet onto another sheet.
Within that sheet I have that data which I need to transfer that figure into another cell. (one of 4 or 5)
Now the problem I can't solve or find a result for is:
If the number is between lets say 1-99 it needs to go into a specific cell for further calculation.
If the number is between 100-199 it needs to go into a specific cell different to the one above it.
and so on.
MS EXCEL 2010
I used to be able to do it in the old 2003 version under conditional formatting but I can't seem to work it out/find the right bit in this version.
I want to try to avoid it but I can screenshot what I need to do if it makes no sense.