Formula Help!!

Wilcock1

New Member
Joined
Dec 11, 2014
Messages
25
Hi,

Please can you help with resolving a formula query that I have.

Cell AK2 is 01/01/19 (showing as Jan 2019 due to formatting)

Cell H227 I have 25/01/19

Cell L227 I have =IF(H227=0,"",H227) which shows as Jan 2019 again due to formatting.

Cell S227 has £20.00.
I would like my formula to be something like
=if(L227=AK2, S227,0) which would show £20.00.

However, I am getting £0.00 which I think is either due to formatting or that 01/01/19 does not equal 25/01/19 but I want the result to work as both cells show as Jan 2019.


Any assistance would be greatly appreciated!!

Regards

Andrew
 
Last edited:

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,095,372
Messages
5,444,076
Members
405,265
Latest member
Iram

This Week's Hot Topics

Top