Hello,
The attached file have this formula:
What I am trying to do is – for those dates that are greater than the “FSDate” should be invisible until it either older or equal the “FSDate”.
Please Login or Register to view this content.
The formula, I have is not doing what I want it to do. Please help!
Thank you,
Cheryl
You havent even got a greater than sign in the formula.
Do you mean this?
in B13
=IFERROR(IF(EDATE(B12,12) > $D$5,"",EDATE(B12,12)),"")
and copy down.
If you dont want the figures to show on the same row then reenter the formulas for columns E:N enclosing whatever the formula is within this formula
=IF($B8="","",formula)
e.g.
for E8
=IF($B8="","",SUM(C18:D18))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi Special-K,
Thank you for responding.
I meant this formula, but you solved my problem.Please Login or Register to view this content.
Thank you,
Cheryl
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks