T(IF function returning #value...how can i get this to work?

abso111111

New Member
Joined
Nov 25, 2005
Messages
2
How can I get this function to properly work?

{(T(IF(Sheet1!b4,"text data",sheet1!b16))}

it only returns #VALUE!
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Take out the comma after B4= and don't use curly parenthesis.

It worked for me when i place "text data" in B4 and had a string in B16.

=(T(IF(Sheet1!B4="text data",Sheet1!B16)))
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi abso1...

Welcome to MrExcel Board!

How about describing 1) what you are trying to do, and 2) what entries are in cells B4 and B16 of Sheet1!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,335
Messages
5,571,608
Members
412,407
Latest member
ElmerCC
Top