Get rid of #VALUE, after multiplying
If my formula is trying to multiply one empty field with another empty field
that is fine. But if I am trying to multiply an empty field with another empty field that has a formula in it (specifically a VLOOKUP) I get a #VALUE error. How do I get that to go away and be ignored? |
Get rid of #VALUE, after multiplying
It sounds like the result of your VLOOKUP is a formula blank ("") which is a
TEXT value. So: number * formula blank = #VALUE! Let's assume the VLOOKUP is in cell A1 and you want to multiply that by cell B1: =N(A1)*B1 If A1 is a formula blank ("") the result will be 0. -- Biff Microsoft Excel MVP "kbouquet" wrote in message ... If my formula is trying to multiply one empty field with another empty field that is fine. But if I am trying to multiply an empty field with another empty field that has a formula in it (specifically a VLOOKUP) I get a #VALUE error. How do I get that to go away and be ignored? |
All times are GMT +1. The time now is 02:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com