VBA script for if-else

My columns look like these for Column G, need a if else script: Column G Complete Complete In progress Not Started Complete

A script to Convert all Complete values to 'Y' otherwise 'N'