If function that calculates

I'm trying to create a if then statement in excel. My result is going in
column P, I want the value of column O to be tested.

I have three values in column O 25, 17 and 15.

If O3 = 17, then P3=the value in m3,
If O3 = 25, then P3=the value in I3,
If O3 = 15, then P3=the value in N3

I've tried for days to figure this out and don't remember all the ways I've
tried to get it to work. Since there is one of the three values in this
Column O, I don't need a final statement. but I guess maybe this is my
mistake. The formula will always net a result since I have one of the three
values in row O.
=IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

You have to type the formula in the cell you want the value to appear in.
The formula you have written is comparing the values in P3 and M3, P3 and
I3, P3 and N3 so you will be getting a TRUE or FALSE result
Omit the P3= part of the formula and you should have a result.




"Ernie [email protected]" <Ernie
[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways
> I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the
> three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

try entering in Cell P3
=if(O3=25,I3,if(O3-17,M3,N3))
if one of the three values will be in each cell otherwise

=if(O3=25,I3,if(O3-17,M3,if(O3=15,N3,"Else")))



"Ernie [email protected]" wrote:

> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

In cell P3 try
=IF(O3=17,M3,IF(O3=25,I3,IF(O3=15,N3,"")))

HTH

"Ernie [email protected]" wrote:

> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

An alternative to IF:

=INDIRECT(LOOKUP(O3,{15,"N3";17,"M3";25,"I3"}))

HTH
Jason
Atlanta, GA

"Ernie [email protected]" wrote:

> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

> I have three values in column O 25, 17 and 15.

If these are the only values, perhaps another option in cell P3.

=OFFSET(P3,0,-MOD(632, O3))
--
Dana DeLouis
Win XP & Office 2003


"Ernie [email protected]" <Ernie
[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways
> I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the
> three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))

=IF(O3=17,M3,0)+IF(O3=25,I3,0)+IF(O3=15,N3,0)

"Ernie [email protected]" wrote:

> I'm trying to create a if then statement in excel. My result is going in
> column P, I want the value of column O to be tested.
>
> I have three values in column O 25, 17 and 15.
>
> If O3 = 17, then P3=the value in m3,
> If O3 = 25, then P3=the value in I3,
> If O3 = 15, then P3=the value in N3
>
> I've tried for days to figure this out and don't remember all the ways I've
> tried to get it to work. Since there is one of the three values in this
> Column O, I don't need a final statement. but I guess maybe this is my
> mistake. The formula will always net a result since I have one of the three
> values in row O.
> =IF(O3=17,P3=M3,IF(3="25",P3=I3,IF(O3="15",P3=N3)))