I am setting up a template for my trades to fill out.
In the attached pic I have set it up so when the guys enter a code total value in column F it will automatically add the travel amount (4.90) to column G. That part is fine.
I need to know a formula to add to =SUM(F14+4.9) that will leave cell blank when there is no value in the F column
eg. =SUM(F14+4.9) (if F14=blank cell, G14=blank cell) S I don't have all the $4.90's filled where not needed.....
I am new to excel and am struggling to find an answer on existing forums, any help would be great....
Thanks....
Bookmarks