Hi Tony,
I tried this and it seams to work! =IFERROR(1/(1/(L24+K24-1)),"")
Thank you for your help and assistance! Very much appreciated!
Dave
Hi Tony,
I tried this and it seams to work! =IFERROR(1/(1/(L24+K24-1)),"")
Thank you for your help and assistance! Very much appreciated!
Dave
If L24 or K24 contain formulas that return formula blanks "" then you'll get the #VALUE! error if you try to do math operations on them:
=L24+K24-1
Thanks for the feedback!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks