hi, i want to do an equation in excel with if condition: i have planned, actual and condition columns if planned = actual then the condition is on time if actual > planned then condition is late if actual < planned then condition is on time My problem is: when i drag the equation down, i will have balnk cells for planned and actual, so i get the result for this one on time, where i need it to be zero or "-", so when i do filter in future for on time i want the filled cells.
Solved by O. A. in 12 mins