Relating today to other dates
Closed
Carolina
-
Apr 6, 2016 at 09:54 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 8, 2016 at 06:51 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Apr 8, 2016 at 06:51 AM
Related:
- Relating today to other dates
- Gamescom 2023 dates - Guide
- Defcon 2023 dates - Guide
- Nintendo direct 2023 dates - Guide
- How would you change these dates to the dd/mm/yyyy format? - Guide
- Steam sale dates - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.