Basic IF loop & commands for an entire column?

Hello everyone,

I've been googling with no luck.

What commands do I need to do the following..

Run the following through a column until there are empty rows..

.. Check each value, and IF the value is between -20 and 0..
Change the exact cell contents to -20.99
Change another column on the SAME row to a different value.

There are a few different cases (if it's 0 to +10) that require other changes.


OR if you want to see my exact requirements, I've attached the Excel file.

Thanks so much everyone,
Daniel.

Hello friend,

I have a question before I get started. In your example workbook if range AA4 is between 0 and -20.98 does range AA4 need to be changed to -20.99 or does the range AA5:AA7 need to be changed. Let me know.

Also

Change another column on the SAME row to a different value.

What column needs to be changed?