Jun 21 2019 02:00 AM
Hi, see the attached document. I've used a formula:
=IF(ISNUMBER(SEARCH("Jan",C3)),D3,0)
for cell G3, why is'nt this picking up that there is 'Jan' in C3 and thus producing the value in D3?
Thanks, Bailey100
Jun 21 2019 02:06 AM
Solution
In C3 you have a number, it's only formatting on the top. Use
=IF(TEXT(C3,"mmm")="Jan",D3,0)
Jun 21 2019 02:10 AM
Jun 21 2019 02:25 AM
Given that the expected result is a number, you may also use this Boolean formula:
=(TEXT($C3,"mmm")=G$2)*$D3
Jun 21 2019 02:06 AM
Solution
In C3 you have a number, it's only formatting on the top. Use
=IF(TEXT(C3,"mmm")="Jan",D3,0)