Double if statement - Simple i think?

[Raj1313]

Hi i have the below - i want colum B to do the following = IF A1 is False the show "-" and also if the prevoius cell in row A is False then show No (example if A1 is False B2 is No

False	-
0	No
False	-
0	No
0	-
0	-
False	-
-	No

<tbody>
</tbody>

 

[live_excel]

Hello Raj

Please use this formula:
=IF(A1=FALSE,"-",IF(INDIRECT("A" & ROW() - 1)=FALSE,"NO","-"))

And also let me know.

 

[chicagocomputerclasses]

=IF(A1=FALSE,"-",IF(OFFSET(A1,-1,0)=FALSE,"No","-"))

 

[Raj1313]

Brillaint that worked - Anyway to simply this - its going to go down approx 10k rows? dont wont to slow the document down.

 

[Trustee]

Hi there,

I have tried the formula and I think this is what you are asking for:

https://docs.google.com/spreadsheets/d/1ol5LyFwJKQnuU0PuFzPHLe28KI7m6koX4ZrZFVXolno/edit#gid=0

 

[Raj1313]

Thanks Both - Both of formulas work!!

 

[Raj1313]

i Clicked that link nothing worked - thanks anyway.

 

[63falcondude]

Brillaint that worked - Anyway to simply this - its going to go down approx 10k rows? dont wont to slow the document down.

Try =IF(A1=FALSE,"-",IF(INDEX(A:A,ROW()-1)=FALSE,"No","-"))

 

[Raj1313]

HI Guys the data is in row J2 onwards and the formula will be in K2 onwards - How would I rearrange this formula - I have changed the cells but it doesn't seem to work?

 

[63falcondude]

HI Guys the data is in row J2 onwards and the formula will be in K2 onwards - How would I rearrange this formula - I have changed the cells but it doesn't seem to work?

Try

Excel 2010
	J	K
1
2	FALSE	-
3	0	No
4	FALSE	-
5	0	No
6	0	-
7	0	-
8	FALSE	-
9	-	No
Sheet1

Cell Formulas
Range	Formula
K2	=IF(J2=FALSE,"-",IF(INDEX(J:J,ROW()-1)=FALSE,"No","-"))