Quote Originally Posted by IAHokie View Post
In the column where you want the answer put: If(Isblank(C1), E1+D1, E1-C1)
You may want to specify different row numbers
If C1 is blank, then true, then E1+D1 is executed
If C1 is not blank, then false, then C1+D1 is executed
this worked - many thanks!