LinkBack URL
About LinkBacks
famchiroly 
I have an average of column L where this formula is placed. K15 is blank but if any value is placed in F15 it is read as 0 and returns a value. I only want a value in this cell if K15 is 0 or greater.
=IF(K15>=0,(F15-K15)/F15,0)
I have an average of column L where this formula is placed. K15 is blank but if any value is placed in F15 it is read as 0 and returns a value. I only want a value in this cell if K15 is 0 or greater.
=IF(K15>=0,(F15-K15)/F15,0)
Maybe this
=IF(K15<>"",(F15-K15)/F15,"")
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
You Rock! Works perfect and leaves the cell blank too! I'm so use to having the #DIV/0 error there.
You're welcome and thank you for your feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks