On Sheet "Current" in Column K I need it to say (K5)
if J5<>"DOM",J5
if it does equal "DOM" then if the total volume (Column G) of Port 1 (Column J) for DOM is < 100 then DOM1
if the total volume (Column G) of Port 1 (Column J) for DOM is 100 to <250 then DOM2
if the total volume (Column G) of Port 1 (Column J) for DOM is 250 to <500 then DOM3
if the total volume (Column G) of Port 1 (Column J) for DOM is 500 or > then DOM4
I know this should be fairly easy, but I can't figure it out.
Thank you
Bookmarks