Or you could reverse the logic in your second formula to check if cell H3 contains a number, rather than a blank. It would look something like:
=IF(ISNUMBER($H3),($G3+$I3),"")
Or you could reverse the logic in your second formula to check if cell H3 contains a number, rather than a blank. It would look something like:
=IF(ISNUMBER($H3),($G3+$I3),"")
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks