IF statements giving me trouble...

[Twisty20]

Ok guys, you have been my savior thus far. Now, this is a real stumper...

I need to figure out the date to which I can put in a notice to redeem from a fund. However, the catch is some are on Quarterly, Monthly or even Yearly schedules, with different notice periods. (Meaning, I can't get my money back until the closest quarter to the date allowed, and putting in the appropriate notice in time.)

If anyone can find the best way to calculate this using my spreadsheet below, that would be GREAT. I have been thinking about this all day, and I haven't even gotten close.

Thanks in Advance!!

[Bryan Hessey]

Ok guys, you have been my savior thus far. Now, this is a real stumper...

I need to figure out the date to which I can put in a notice to redeem from a fund. However, the catch is some are on Quarterly, Monthly or even Yearly schedules, with different notice periods. (Meaning, I can't get my money back until the closest quarter to the date allowed, and putting in the appropriate notice in time.)

If anyone can find the best way to calculate this using my spreadsheet below, that would be GREAT. I have been thinking about this all day, and I haven't even gotten close.

Thanks in Advance!!

Hi,

Using the Year, and the Month of the investment date, and the number 28 for the day, you have the end of the current month. (close enough)

Adding 89 gives you the end of next quarter, (90 fails every 99 years Jan/Feb/Mar are only 89 days, 90 on leap years)

Round the Month up in 3's to get a Quarter.

Adding a year (365) and subtracting 60 gives you one of your dates.

Does this help with your ideas?
---

[Twisty20]

Hi,

Using the Year, and the Month of the investment date, and the number 28 for the day, you have the end of the current month. (close enough)

Adding 89 gives you the end of next quarter, (90 fails every 99 years Jan/Feb/Mar are only 89 days, 90 on leap years)

Round the Month up in 3's to get a Quarter.

Adding a year (365) and subtracting 60 gives you one of your dates.

Does this help with your ideas?
---

Thanks for your help! It did aid in my thought process for evaluating the conditional formula...now that I have them I must condese them.

On a more simpler note, how to you make a formula that displays a result? Meaning, I have 5 conditional formulas, but only one will be true for given inputs. How can I make one cell display the result, so I can hide the columns w/ the formulas?

[Bryan Hessey]

Thanks for your help! It did aid in my thought process for evaluating the conditional formula...now that I have them I must condese them.

On a more simpler note, how to you make a formula that displays a result? Meaning, I have 5 conditional formulas, but only one will be true for given inputs. How can I make one cell display the result, so I can hide the columns w/ the formulas?

Hi,

rather a vague question, so a vague answer

=If(condition-A,Display-results-A,If(condition-B,Display-results-B,If(condition-C,Display-results-C,If( .... etc ))))

Does this help you?
---

[Twisty20]

Hi,

rather a vague question, so a vague answer

=If(condition-A,Display-results-A,If(condition-B,Display-results-B,If(condition-C,Display-results-C,If( .... etc ))))

Does this help you?
---

In short, yes. But how do I get it to display a true answer that displays a number? Meaning, 4 of the 5 columns will say 'FALSE', and one of them will be a Date (result of conditional formula). So to say, what do I replace the "A's" with in your equation? Should I use 'ISNUMBER(XX)'??

Thank you for your continued patience,

Alan

[Bryan Hessey]

In short, yes. But how do I get it to display a true answer that displays a number? Meaning, 4 of the 5 columns will say 'FALSE', and one of them will be a Date (result of conditional formula). So to say, what do I replace the "A's" with in your equation? Should I use 'ISNUMBER(XX)'??

Thank you for your continued patience,

Alan

Hii,

I guess you didn't try it.

The formula was

If (condition , true=display-answer , false = test-next-condition-If-conditionB , b-true=display-answerB , false = test-next-condition-If-conditionC , c-true=display-answerC , false = test-next-condition-If

Does that answer your question?
---

[Twisty20]

Hii,

I guess you didn't try it.

The formula was

If (condition , true=display-answer , false = test-next-condition-If-conditionB , b-true=display-answerB , false = test-next-condition-If-conditionC , c-true=display-answerC , false = test-next-condition-If

Does that answer your question?
---

Brian,

Ok, I understand the IF statement now. However, how can I test whether the formula is giving an answer or not? You write 'condition', however what is the condition? ISNUMBER would not work in this instance would it? Also one more q: When you write 'Display-Answer', is that the exact input for the forumula?

Thank you, you are a huge help!

EDIT: I just got it!

=IF(ISNUMBER(N10),N10,IF(ISNUMBER(O10),O10,IF(ISNUMBER(P10),P10,0)))

Thanks for your help. I've noticed that you like to help out a lot!

[Bryan Hessey]

Brian,

Ok, I understand the IF statement now. However, how can I test whether the formula is giving an answer or not? You write 'condition', however what is the condition? ISNUMBER would not work in this instance would it? Also one more q: When you write 'Display-Answer', is that the exact input for the forumula?

Thank you, you are a huge help!

EDIT: I just got it!

=IF(ISNUMBER(N10),N10,IF(ISNUMBER(O10),O10,IF(ISNUMBER(P10),P10,0)))

Good to see it worked for you, and in answer to your question prior to that resolution, you asked "Meaning, I have 5 conditional formulas, but only one will be true for given inputs. How can I" but no further indication as to what the formula was, thus the generic answer was given using 'Condition' whereas I should have expressed the formula as I normally would using 'Logical_Test' instead of 'Condition'.

Thanks for your response, it's always good to see a problem solved.

---