prob in IF then else statement
I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK
worksheet, heres my formula in cell C8 =IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if DEADLOAD!A20 is blank and A21(A21 instead of A20) has a value, and I want the result to be on cell C8.. and if A21 is followed with a value at A22, I want the result to be on cell C9.. Hope you get what I mean... thanks.... |
prob in IF then else statement
=INDEX(A:A,MIN(IF(A20:A30<"",ROW(A20:A30))))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "RYNNER" wrote in message ... I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK worksheet, heres my formula in cell C8 =IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if DEADLOAD!A20 is blank and A21(A21 instead of A20) has a value, and I want the result to be on cell C8.. and if A21 is followed with a value at A22, I want the result to be on cell C9.. Hope you get what I mean... thanks.... |
All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com