IF Statement or nested IF
 

I have 4 stations , lets say A, B, C, D with daily Temperature Data, I want
fill up missinf data "M" for station A from stations B,C,D; if I write =if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks

IF Statement or nested IF
 

Hi Rahim

Try the below formula in cell A2
=INDEX(B2:D2,MATCH(TRUE,INDEX(B2:D2<0,),))

If this post helps click Yes
---------------
Jacob Skaria


"Rahim" wrote:

I have 4 stations , lets say A, B, C, D with daily Temperature Data, I want
fill up missinf data "M" for station A from stations B,C,D; if I write =if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks

IF Statement or nested IF
 

Correction. Try the below. ... for "M"

=INDEX(A2:D2,MATCH(TRUE,INDEX(A2:D2<"M",),))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hi Rahim

Try the below formula in cell A2
=INDEX(B2:D2,MATCH(TRUE,INDEX(B2:D2<0,),))

If this post helps click Yes
---------------
Jacob Skaria


"Rahim" wrote:

I have 4 stations , lets say A, B, C, D with daily Temperature Data, I want
fill up missinf data "M" for station A from stations B,C,D; if I write =if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks

IF Statement or nested IF
 

Do you need all 4, if there, or just the last one
This will find the item in the LAST filled column on row 1
=MATCH(999999,1:1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rahim" wrote in message
...
I have 4 stations , lets say A, B, C, D with daily Temperature Data, I
want
fill up missinf data "M" for station A from stations B,C,D; if I write
=if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have
missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station
D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks

IF Statement or nested IF
 

Using IF..
=IF(A2<"M",A2,IF(B2<"M",B2,IF(C2<"M",C2,IF(D2< "M",D2,"No values found"))))

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hi Rahim

Try the below formula in cell A2
=INDEX(B2:D2,MATCH(TRUE,INDEX(B2:D2<0,),))

If this post helps click Yes
---------------
Jacob Skaria


"Rahim" wrote:

I have 4 stations , lets say A, B, C, D with daily Temperature Data, I want
fill up missinf data "M" for station A from stations B,C,D; if I write =if
(a2="M", b2, a2) to get datat from staion B, BUT station B may have missing
"M" so I need to get the data from station C for that particular date and
again if Station C has "M" for the same day I need to get it from station D.
so

should I write
=IF(D2="M",E2*(IF(E2="M",F2,E2),D2))

but this gives me result "FALSE", can anybody help me

I appreciate your help, thanks