Relating today to other dates
Closed
Carolina
-
Apr 6, 2016 at 09:54 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 8, 2016 at 06:51 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 8, 2016 at 06:51 AM
Related:
- Relating today to other dates
- Different dates of "end to end encryption message" on blank chat? - Excel Forum
- How to highlight overdue dates in excel ✓ - Excel Forum
- Defcon dates - Guide
- How to activate facebook dating - Guide
- Webpage blank - Internet & Social Networks Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Apr 8, 2016 at 06:51 AM
Apr 8, 2016 at 06:51 AM
Hello Carolina,
Make the following adjustments to your formula:-
From:-
to
I'm assuming that you know that the formula needs to be placed in any cell other than M38, A197 or O38 otherwise you will receive a circular reference error with the result being 0.
I hope that this helps.
Cheerio,
vcoolio.
Make the following adjustments to your formula:-
From:-
=IF(M38>=A197;(M38);(O38))
to
=IF(M38>=A197,M38,O38)
I'm assuming that you know that the formula needs to be placed in any cell other than M38, A197 or O38 otherwise you will receive a circular reference error with the result being 0.
I hope that this helps.
Cheerio,
vcoolio.
