Excel "#VALUE" help

Matt T

New Member
Joined
Jan 24, 2004
Messages
1
I need help getting a spreadsheet funtion correct? I keep getting the #VALUE in the cell. I have an IF funtion in a column that gives a cell value if the argument is true and a space eg. " " if the argument is false. The #value is displayed in a different cell that is referring to the false argument.

I hope I am clear enough for you to understand???
If not I am sorry.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
do ya mind if i ask to see your formula? curious.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,150
Members
410,543
Latest member
ExcelGlenn
Top