Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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)) ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |