Hi guys, first post here!

I used Excel at school but more so Access, but anyway. What I'm trying to do is make use of the IF statement.

For instance, as an example I have colours in column A, and prices in column B. If the colour is Red, how do I add £1 to the price in column B.

We would have to do this on files with 1000's of records in so it is possible to do this in a macro as well?

So to summarize. If the colour of the item is red the price gets increased by £1. If it's not red, i.e. any other colour in the column the price stays the same.

Cheers!