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!
"All that is gold does not glitter,
Not all those who wander are lost."
TechSideline.com (a.k.a. TSL) is an independent publication that is in no way affiliated with or sponsored by Virginia Tech or the Virginia Tech Athletic Department. This site is best viewed using Mozilla Firefox or MS Internet Explorer at a video resolution of 1024x768 or higher. For more details, including a list of TechSideline staff, see our Contact Page. All original material and images are copyrighted by TechSideline.com and may not be reused or reprinted without permission.