I'm having problems with my sum of B * E= into F. when boxes B & E are empty "value!" error pops up. How would I do this to remove the value error?
Thanks!
I'm having problems with my sum of B * E= into F. when boxes B & E are empty "value!" error pops up. How would I do this to remove the value error?
Thanks!
Maybe
=IF(COUNT(B1,E1)=2,B1*E1,"")
HTH
Regards, Jeff
write the formula =IFERROR(your formula)
Hi Bill,
If you went this route then it would be,
=IFERROR(value,value_if_error)
=IFERROR(B1*E1,"")
Thanks Jeff, Sorry about the brevety of my last post.
No worries.
Here's a little tip to copy the format of a formula so you get =IFERROR(value,value_if_error) without having to type it out.
Place your cursor in a cell and begin typing out what you are searching. Once the formula comes up, hit tab to fill it out to =IFERROR(
Now select Ctrl + Shift + A and you will get =IFERROR(value,value_if_error) and not just copy and paste to wherever.
Thanks alot Jeff!
You're very welcome Bill. Glad you got it all sorted out and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks