Amit Punia
Member
Need a formula for 2 IF conditions for the attached file.
Formula for 2 IF conditions
- Thread starter Amit Punia
- Start date
Amit Punia
Member
C2 is purposely kept blank. Cell H3 is just blank. Actually the date from H2 should be in other sheet, I pasted in the same sheet.
GraH - Guido
Well-Known Member
Hi Amit Punia, are you sure of the data lay-out and requirements?
If C2 is intentionally left blank, why would you need to evaluate it as is not blank? That is not clear for me.
The date in H2 is first of month. In B2 you always use end of month.
You compare both values. That will never work. Perhaps you want EOMONTH(B3,0)+1?
The possible formula =IF(B3=$H$2,$H$2,IF($C$2<>"",EOMONTH($C$2;1);"")) returns always BLANK in your file. I have 1 match with the corrected formula in B.
Could that be what you are after?
If C2 is intentionally left blank, why would you need to evaluate it as is not blank? That is not clear for me.
The date in H2 is first of month. In B2 you always use end of month.
You compare both values. That will never work. Perhaps you want EOMONTH(B3,0)+1?
The possible formula =IF(B3=$H$2,$H$2,IF($C$2<>"",EOMONTH($C$2;1);"")) returns always BLANK in your file. I have 1 match with the corrected formula in B.
Could that be what you are after?
Amit Punia
Member
C2 is blank but as you go down, the formula should check this condition in C4, C5 and so on whether that is blank or not. It will check all the cell till the bottom for all the cells.
We can change the date in H2 from beginning of the month to end of the month. In that way the formula would work perfectly.
We can change the date in H2 from beginning of the month to end of the month. In that way the formula would work perfectly.
GraH - Guido
Well-Known Member
Could you add in your file an extra column and fill in what the result should be according to your requirements?