Looking to create a macro in excel to replace the manually IF function that I use. Is there a way?
For example I have 2 sheets of data that I Vlookup together, then calculate the percent difference. I need to produce a MACRO that states IF(E2>2%,"ALERT","BELOW TOLERANCE")
Bookmarks