I have developed a spreadsheet for my department which has tasks associated with employees. The conditions are tasks are Open, In Process, Delayed, or Closed. If the condition is Closed (cell V27) I want to make (Cell B27 blank). I can do that with =IF(V27="Closed","","") However if the condition is In Process, Delayed, or Closed, I want to copy the value in cell B27 in a different section of the sheet. If I do =IF(V27<>"Closed") I get true or false. What can I do with the formula instead of writing VBA code?
Best Regards,
Derrick Smith
Bookmarks