Multi IF Formula not working

[BernardJWright]

Hoping someone can find the quick and easy fix to this.
P26 should equal U2, but I can't see why not.

Cheers all!

 

[Peter_SSs]

Welcome to the MrExcel board!

We cannot see your row numbers or copy that data for testing.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[BernardJWright]

Screenshot showing Row and Columns now

 

[Peter_SSs]

Thanks, but that still would require a lot of manual typing (with possible errors) and not knowing whether the date/time cells are numerical or text etc.
Also, your initial post/image referred to P26 & showed a formula.
This latest image looks like it is P24 not P26.
An XL2BB sample would easily resolve all that. Best if you can make it as easy as possible for people who want to help you.

 

[RoryA]

Your formula logic is wrong because you used & instead of AND() and you refer to O24 and O26 in different parts; I can't tell if that is intentional

 

[Alex Blakenburg]

There are a number of inconsistencies as has already been pointed out. Taking a guess at them give this a try.

=IF(O24="PMC",$R$2*O25,IF(O24="AKE",$S$2*O25,IF(AND(O24="LOOSE",E24>=400),E24*$T$2,IF(AND(O24="LOOSE",E24<=399),$U$2,"NONE"))))

I find it easier to read if you do something this:

=IF(O24="PMC",
          $R$2*O25,
           IF(O24="AKE",$S$2*O25,
                 IF(AND(O24="LOOSE",E24>=400),
                       E24*$T$2,
                       IF(AND(O24="LOOSE",E24<=399),
                              $U$2,
                             "NONE"))))