Forum Discussion
Solved
IF formula help
I am trying to write a formula, that will automatically fill if Cell C34 is greater than 0 and fill in a few other cells. In the attachment, if Cell34 is greater than 0, I would like for Cell B35 to...
drt_80 , you can use these formulas.
In cell B35 (you had manually entered the 31st September, but September has only 30 days)
=IF(C34>0,EOMONTH(B34,1),"")
in cell C35
=IF(B35<>"",VLOOKUP(B35,$A$17:$H$32,8,FALSE),0)
in cell B39
=IF(C36>0,EOMONTH(B35,1),"")
in cell C40
=IF(B39<>"",VLOOKUP(B39,$A$17:$H$32,8,FALSE),0)
drt_80 , you can use these formulas.
In cell B35 (you had manually entered the 31st September, but September has only 30 days)
=IF(C34>0,EOMONTH(B34,1),"")
in cell C35
=IF(B35<>"",VLOOKUP(B35,$A$17:$H$32,8,FALSE),0)
in cell B39
=IF(C36>0,EOMONTH(B35,1),"")
in cell C40
=IF(B39<>"",VLOOKUP(B39,$A$17:$H$32,8,FALSE),0)
IngeborgHawighorst Perfect, Thank you!
