I am trying to figure out how to change a cell depending on what is done in another cell. I currently have a cell (V32) that a percentage is entered and it calculates dollar amount (Y30*V32) in another cell (Y32), is there a way that I can either enter the percentage as we do now but have the option to enter a $ amount in Y32 and have it calculate the percentage in V32 (Y32/Y30). So basically I want those cells to be interchangeable for the calculation. I'm thinking I can do it in VBA but I've hit a mental block on how. Thank you for any help.
Bookmarks