Multiple If Function with priority
Closed
jenn
-
Oct 21, 2016 at 11:38 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 21, 2016 at 02:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 21, 2016 at 02:05 PM
Related:
- Multiple If Function with priority
- Allow multiple downloads chrome - Guide
- Find function on mac - Guide
- How to delete multiple files on mac - Guide
- Photoshop multiple selections - Guide
- Accessor function c++ - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 21, 2016 at 12:57 PM
Oct 21, 2016 at 12:57 PM
jenn, Good afternoon.
Try to use:
=IF(OR(AP145="Active", AP145="Pending"),"Completed", IF($R145="Yes", "Pending", IF($R145="No", "x", IF($R145="", "",""))))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=IF(OR(AP145="Active", AP145="Pending"),"Completed", IF($R145="Yes", "Pending", IF($R145="No", "x", IF($R145="", "",""))))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 21, 2016 at 02:05 PM
Oct 21, 2016 at 02:05 PM
jenn,
1)
"...Before it would provide me todays date and change every day. Ideally I would want to have that date to stay the same and not change unless cell AN changes..."
TODAY() and NOW() functions are DINAMIC.
They updated automatically.
If you want a fixed date you must enter it manually or develop a VBA programation.
2)
"...However after the formula you help me with was enterred I am getting the statement FALSE. ..."
When at IF Function the Action for the false clause is ommitted Excel return you a word FALSE.
Take a look at your IF functions. You never put any action to the False clauses.
3)
Try to use:
=IF(OR($AN145="Pending", $AN145="Complete"), TODAY(), IF($AN145="x", "x", ""))
Please, tell us if worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1)
"...Before it would provide me todays date and change every day. Ideally I would want to have that date to stay the same and not change unless cell AN changes..."
TODAY() and NOW() functions are DINAMIC.
They updated automatically.
If you want a fixed date you must enter it manually or develop a VBA programation.
2)
"...However after the formula you help me with was enterred I am getting the statement FALSE. ..."
When at IF Function the Action for the false clause is ommitted Excel return you a word FALSE.
Take a look at your IF functions. You never put any action to the False clauses.
3)
Try to use:
=IF(OR($AN145="Pending", $AN145="Complete"), TODAY(), IF($AN145="x", "x", ""))
Please, tell us if worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Oct 21, 2016 at 01:25 PM
=if($AN145="Pending",TODAY(),IF($AN145="Sent",TODAY(),IF($AN145="Complete",TODAY(),IF($AN145="x","x"))))
Before it would provide me todays date and change every day. Ideally I would want to have that date to stay the same and not change unless cell AN changes (which has the formula you provided). However after the formula you help me with was enterred I am getting the statement FALSE.
Would you be able to assist me?
Oct 21, 2016 at 01:44 PM