Two IF forumlas inside an IF formula
Solved/Closed
AdrianHowland
Posts
4
Registration date
Wednesday 4 October 2017
Status
Member
Last seen
10 November 2018
-
4 Oct 2017 à 10:39
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 6 Oct 2017 à 11:46
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 6 Oct 2017 à 11:46
Related:
- Two IF forumlas inside an IF formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
- Spreadsheet formula - Guide
- Number to words in excel formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
4 Oct 2017 à 14:39
4 Oct 2017 à 14:39
AdrianHowland, Good afternoon.
Possibly your problem is much simpler than it seems to present your explanation.
I'm not sure I fully understood your doubt
Try to use this structure:
=IF(M3="Delayed", ONE IF formula, IF(M3="Immediate", A different IF formula, "" )
Try replacing the "ONE IF formula" and "A different IF formula" with your actual IF formula.
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Possibly your problem is much simpler than it seems to present your explanation.
I'm not sure I fully understood your doubt
Try to use this structure:
=IF(M3="Delayed", ONE IF formula, IF(M3="Immediate", A different IF formula, "" )
Try replacing the "ONE IF formula" and "A different IF formula" with your actual IF formula.
Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
6 Oct 2017 à 11:46
6 Oct 2017 à 11:46
AdrianHowland, Good morning.
Thanks for the feedback.
Have a nice weekend!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thanks for the feedback.
Have a nice weekend!
--
Belo Horizonte, Brasil.
Marcílio Lobão
5 Oct 2017 à 04:46
=IF('Project Details'!D4="Delayed","IF(ISBLANK('Project Details'!E32),"","PAID")",IF('Project Details'!D4="Immediate",""))
I am assuming I have gone slightly wrong there as when I try to add it in I get the message "There is a problem with this formula"
I am wondering if perhaps I have put certain symbols in the wrong place the two different IF forumals I am trying to use are as below
- Delayed - IF(ISBLANK('Project Details'!E32),"","PAID")
- Immediate - IF('Project Details'!D4="Immediate","")
I basically want to be able to write in two different formulas that work depending on a cell saying Delayed & Immediate, they I will have to make a few different versions of this formula for different cells, but they will say either PAID or nothing depending on if another cell has anything in it, if it is Delayed than it will be looking at one cell - 'Project Details'!E32
If it says Immediate then it will be looking at another cell - 'Project Details'!D4
Does this makes sense?
Thank you for your time.
Adrian
5 Oct 2017 à 05:27
=IF('Project Details'!D4="Delayed",IF(ISBLANK('Project Details'!G32),"","PAID"),IF('Project Details'!D4="Immediate",IF(ISBLANK('Project Details'!G31),"","PAID")))
It seems to be working fine and I realised from looking at your code, Mazzaropi, that I had added " around the inner IF code which I assume was causing it not to work.
Thank you so much for your help, when you are getting these formulas correct you feel great, as soon as you make a mistake though it has me pacing the whole house! haha
Thank you for your time.