Need a little help with this please. I need a formula to do the following:
Formula in cell L9: sum of - if K9 has a value > 0, then add to K8 and if K9 has no value then leave L9 blank
I need to take a class!
Thanks for the assist!!
Need a little help with this please. I need a formula to do the following:
Formula in cell L9: sum of - if K9 has a value > 0, then add to K8 and if K9 has no value then leave L9 blank
I need to take a class!
Thanks for the assist!!
Maybe this...
=IF(K9="","",IF(N(K9)>0,K9+K8,""))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
OMGosh - that's it! Plugged it in and viola!
Thanks a million, Mr. Tony!
I am going to search out a class soon. Or get the Dummies book and make myself work it to learn it.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks