=IF(TEST, VALUE IF TRUE, IF FALSE DO NOTHING <~~~~????? H

[ARKRUSE]

What do I put in the false value so instead of returning a zero, the function doesnt do anything. So, if true returns x, if false nothing happens.....

 

[Smitty]

Welcome to the Board!

You can use double quotation marks to return nothing.

=If(test,result,"")

Hope that helps,

Smitty

 

[PA HS Teacher]

=If(A1>2,"True Condition","")

 

[ARKRUSE]

Maybe Im using the wrong fucntion
IF A(activity) says running, I want to report B(laps) in a separate table...

When I use the fucntion with the ""'s at the end, it leaves spaces between rows....
like this

5
5

5

5

how do get the fucntion to do nothing, including reporting a blank space? Just do nothing...

 

[Smitty]

You might want to consider AutoFilter to hide null return rows.

But can you post a shot of your data?

You can do that with the HTML Maker (the link can be found at the bottom of the page). That will also include relevant formulas so we can see what you're working with.

Smitty

 

[ARKRUSE]

yea, ive been working with autofilter for a while but im getting some glitches

run bike tread
5 5 5
5 5
5 5
5


when filtered using the auto filter to the "run" collumn...it filters across all the "tables" and therefore "Table: Tread" looses the third row of information. So does bike.

 

[ARKRUSE]

Workout1.xls
	A	B	C	D	E	F
4	Running		Bike		Treadmill
5	laps	timeinmin.	distance	timeinmin.	distance	time
6	5	30.24.96
7			4.35	01.23.01
8					34	45.67.89
9	46	34.67.89
10			45	33.22.44
11	72	11.22.33
12					67	33.22.55
13
14
15
16
17
18
Sheet2

 

[ARKRUSE]

how do i get rid of the spaces between data?
I tried autofilter and it seemes to erase the entire row, when only the first column is blank. Ive tried spacing the separate "tables" but it still filters across the entire row...any suggestions?

 

[Smitty]

Unfortunately, I don't relly see an easy way around this one.

Maybe some one else will have some ideas.

Smitty

 

[ARKRUSE]

I think the only solution will be to put each data set in separate worksheets. Thanks for the help.