Report

Two IF forumlas inside an IF formula [Solved]

Ask a question AdrianHowland 3Posts Wednesday October 4, 2017Registration date October 5, 2017 Last seen - Last answered on Oct 6, 2017 at 11:46 AM by Mazzaropi
Hello,

I am very new to using excel but somehow have managed to bluster my way around so please let me know if I am barking up the wrong tree!

I am trying to make a cell give me a Value (saying 'PAID' or nothing) based on an if formula, (sorry I find this very hard to explain)

So for example if M3 says 'Delayed' then one IF formula if M3 says 'immediate' then a different IF formula.

I want the cell to use a completely different IF forumala based on what one a certain cell says.

I do hope this makes sense, I realise it is very difficult to explain this which is why google search has not helpd much

Helpful
+1
plus moins
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
AdrianHowland 3Posts Wednesday October 4, 2017Registration date October 5, 2017 Last seen - Oct 5, 2017 at 04:46 AM
Hey Mazzaropi, Thank you very much for your quick response and I suppose my I should have given you the example I was trying to make work. So as the part I am trying to work is on two different sheets, this is the formula I was trying to make work -

=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
Reply
AdrianHowland 3Posts Wednesday October 4, 2017Registration date October 5, 2017 Last seen - Oct 5, 2017 at 05:27 AM
My apologies guys, I believe I have figured it out and realised I had only added a part complete formula above. This is what I am using now -

=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.
Reply
Leave a comment
Helpful
+0
plus moins
AdrianHowland, Good morning.

Thanks for the feedback.

Have a nice weekend!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!