IF function Question

drag-driver · Apr 19th, 2002, 04:34 AM

I want to use the IF function in this context

IF the data in cel is #value
then 1
else 2

What to do to indicate #value do

Aladin Akyurek · Apr 19th, 2002, 04:56 AM

Quote:

On 2002-04-19 03:34, drag-driver wrote:
I want to use the IF function in this context

IF the data in cel is #value
then 1
else 2

What to do to indicate #value do

=IF(ERROR.TYPE(A1)=3,1,2)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 04:34 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	I want to use the IF function in this context IF the data in cel is #value then 1 else 2 What to do to indicate #value do