Check info on two different cells...
Solved/Closed
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
Oct 13, 2015 at 11:01 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 14, 2015 at 09:03 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 14, 2015 at 09:03 AM
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT
=IF(Z17="PAID","",IF(F17<>"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
however, in addition to checking the values in cell F17 we need the same formula to check the values in cell L17 as show bellow... my question is what do I have to insert between F17 and L17 for the formula to work without telling me that there are too many values in the formula?
=IF(Z17="PAID","",IF(F17L17<>"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
Thank you in advance, I really appreciate any help coming my way...
=IF(Z17="PAID","",IF(F17<>"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
however, in addition to checking the values in cell F17 we need the same formula to check the values in cell L17 as show bellow... my question is what do I have to insert between F17 and L17 for the formula to work without telling me that there are too many values in the formula?
=IF(Z17="PAID","",IF(F17L17<>"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
Thank you in advance, I really appreciate any help coming my way...
Related:
- Check info on two different cells...
- Check soft - Download - Finance
- Speaker check code - Guide
- How to check if someone is spying on my whatsapp - Guide
- How to check liked posts on x - Guide
- How to check nearby friends on facebook - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 14, 2015 at 09:03 AM
Oct 14, 2015 at 09:03 AM
j1969c, Good morning.
I'm happy to help you.
Helping, I also improve my knowledge.
Have a nice day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm happy to help you.
Helping, I also improve my knowledge.
Have a nice day.
--
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 13, 2015 at 12:21 PM
Oct 13, 2015 at 12:21 PM
j1969c, Good afternoon.
Try to use:
=IF(Z17="PAID","",IF(AND(F17<>"CTF",L17<>"CTF"),"",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=IF(Z17="PAID","",IF(AND(F17<>"CTF",L17<>"CTF"),"",IF(TODAY()>B17+15,"PAY NOW","HOLD")))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
Oct 13, 2015 at 07:40 PM
Oct 13, 2015 at 07:40 PM
OUTSTANDING! What a life saver you are... you saved me tons of time and exasperation! Thank you for being there and for your kindness and time. I REALLY appreciate it! Regards, José Cruz