=IF(E14="",0,S9)
The above is the formula in the cell and instead of it being S9 I need it to be the total of S9+S10
I have tried (S9+S10)) which is the obvious to me but its not working
=IF(E14="",0,S9)
The above is the formula in the cell and instead of it being S9 I need it to be the total of S9+S10
I have tried (S9+S10)) which is the obvious to me but its not working
Mike, that should work. =IF(E14="",0,S9+S10)
What do you have in those 2 cells (exactly)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
maybe this
=IF(E14="",0,SUM(S9,S10))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Perfect Thanks
Thank you for the feedback!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks