IF Statement Help

  • Thread starter Thread starter mccrimmon
  • Start date Start date
M

mccrimmon

Hi there

I want to determine the best method from my two tables with an i
statement.

So im going to have column K as my statement.

Columns A to D are my first table with JP Morgan details
Columns F to I are my second table with Citibank details

Example of table 1 - JPMorgan

Country Type Time Settlement

Argentina 14:00 0
Australia 17:00 -2
Austria 11:00 0


Example of table 2 - Citibank

Country Type Time Settlement

Argentina 14:00 -1
Australia 16:00 -2
Austria 11:00 -1

I want my If statement to use the settlement column as the mos
important. 0 is better than -1

So if Table 1 has 0 and table 2 has -1 i would like the If statement t
put JPM in column K

However if table 1 and table 2 both have 0 then i want another i
statement to say that if there the same go to the time and the late
the time is the best option eg 17:00 better than 16:00

if both time and settlement is the same i want it to say equal

Can someone help me please

Cheer

Attachment filename: deadlines.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=44779
 
Hello:

I mocked up one that may be enough. I mixed upper and
lower case answers in case I missed something (so which
condition answered where).

=IF(C20>H20,"JPM",IF(C20=H20,IF(B20>G20,"jpm",IF
(B20=G20,"EQUAL","citi")),"CITI"))

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
 
excellent work

thanks again for the help

I dont suppose you know how to do my earlier post query at all?

cheers again

Bria
 
Back
Top