Formula

[YOUNAN]

Hello,

I have an excel file in which , cell G23 ( remaining dept fot year 2018 ) equals cell AJ22 ( unpaid depts Year 2019 ).
What i need is a formula that hides the value in cell G23 if its not 2019 yet.

Thanks in advance.

Younan

 

[Joe4]

Wrap it in an IF statement like this:

=IF(YEAR(TODAY())<2019,"",AJ22)

 

[YOUNAN]

Hello Joe4,

Thank you for early reply but the formula is not working.


I copied and paste your formula but i get the following error.


there is a problem with this formula.

Best Regards

Younan

 

[Joe4]

Are you using a version that uses semi-colons instead of commas as arguments separators in formulas (like some European versions do)?

If so, then the formula would look like:

=IF(YEAR(TODAY())<2019;"";AJ22)

If that still does not work, please let us know:
- Where you are located
- If you are using Windows or Mac version
- Which version of Excel you are using (i.e. 2003, 2007, 365, etc)

 

[YOUNAN]

Hello Joe4,

Thank you very much the 2nd formula worked like a charm.
Thank u again.

Best regards
Younan

 

[Joe4]

You are welcome.

That is something that you will want to note for future reference. Most locales use commas to separate formula arguments, but some use semi-colons.
So if you ask other questions and get formulas that do not work, simply try replacing the commas in the formula with semi-colons.