Hello, I'm trying to modify a ton of VLOOKUP formulas to include a round function.
Currently my formulas look like this:
(VLOOKUP(EP11,brshare_sort!$A$6:$IM$329,240,FALSE)/brshare_sort!$IF$6)*100
I want to add the round function to them so they look like this:
ROUND(((VLOOKUP(EP11,brshare_sort!$A$6:$IM$329,240,FALSE)/brshare_sort!$IF$6)*100),0)
Is there an automated way to do this? I have a ton of formulas just like this and I'm hoping I don't have to manually go through every formula on the sheet. The problem is that what I try to to global find and replace I get an error b/c I can only put in half of the modification at a time.
Hope there's a solution out there.
-- Randy
Bookmarks