about an if statement

LMF · Apr 12th, 2002, 03:33 AM

u know if a cell A is negative, in cell B, i can say if cell A < 0, then appears 0, else cell A.

i know this works just to display positive values only, but is there any specific function that can do this, other than just an if statment???

also, when i get an error #N/A, i can use function error.type to convert it to a number, but how come it is always 7, can i change it to a number that i want???

lmk

pls help me!

Aladin Akyurek · Apr 12th, 2002, 04:31 AM

On 2002-04-12 02:33, LMF wrote:
u know if a cell A is negative, in cell B, i can say if cell A < 0, then appears 0, else cell A.

i know this works just to display positive values only, but is there any specific function that can do this, other than just an if statment???

An alternative to IF is the boolean formulation:

=(A1>0)*A1

also, when i get an error #N/A, i can use function error.type to convert it to a number, but how come it is always 7,

Apparently you're using functions that, upon failure, returns #N/A like VLOOKUP, SEARCH, etc.

can i change it to a number that i want???

How do you mean?

If you have #N/A in B1,

=ERROR.TYPE(B1)+5

will simply work. But what is the purpose?

Aladin
[/quote]

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

Apr 12th, 2002, 03:33 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	u know if a cell A is negative, in cell B, i can say if cell A < 0, then appears 0, else cell A. i know this works just to display positive values only, but is there any specific function that can do this, other than just an if statment??? also, when i get an error #N/A, i can use function error.type to convert it to a number, but how come it is always 7, can i change it to a number that i want??? lmk pls help me!

Apr 12th, 2002, 04:31 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	On 2002-04-12 02:33, LMF wrote: u know if a cell A is negative, in cell B, i can say if cell A < 0, then appears 0, else cell A. i know this works just to display positive values only, but is there any specific function that can do this, other than just an if statment??? An alternative to IF is the boolean formulation: =(A1>0)A1 also, when i get an error #N/A, i can use function error.type to convert it to a number, but how come it is always 7,* Apparently you're using functions that, upon failure, returns #N/A like VLOOKUP, SEARCH, etc. can i change it to a number that i want??? How do you mean? If you have #N/A in B1, =ERROR.TYPE(B1)+5 will simply work. But what is the purpose? Aladin [/quote]