# if statement

Experts, if C39 = text then I would need the result to be "Does not Drop Down" and return the formula if otherwise.  I do not know how to write if C39 = some text or letters.
thank you
I get a #Value:
=IF(C39=" ","Does not Drop Down"),\$C\$40*\$B\$42+(\$B\$26*\$B\$40*(\$B\$43/365))+(\$C\$41*\$B\$45)+(\$B\$26*\$B\$41*(\$B\$46/365))+((\$B\$26*\$B\$49)*\$B\$51)+(\$B\$26*\$B\$49*(\$B\$52/365))+((\$B\$26*\$B\$50)*\$B\$54)+(\$B\$26*\$B\$50*(\$B\$55/365))
###### Who is Participating?

x

Commented:
For that you can use this version

=IF(C39="Does not Drop Down",C39,\$C\$40*\$B\$42+(\$B\$26*\$B\$40*(\$B\$43/365))+(\$C\$41*\$B\$45)+(\$B\$26*\$B\$41*(\$B\$46/365))+((\$B\$26*\$B\$49)*\$B\$51)+(\$B\$26*\$B\$49*(\$B\$52/365))+((\$B\$26*\$B\$50)*\$B\$54)+(\$B\$26*\$B\$50*(\$B\$55/365)))

If you explain the scenario where the first formula didn't work, I'm sure there would be a way to address that too

regards, barry
0

Commented:
You can use ISTEXT, i.e.

=IF(ISTEXT(C39),"Does not Drop Down",\$C\$40*\$B\$42+(\$B\$26*\$B\$40*(\$B\$43/365))+(\$C\$41*\$B\$45)+(\$B\$26*\$B\$41*(\$B\$46/365))+((\$B\$26*\$B\$49)*\$B\$51)+(\$B\$26*\$B\$49*(\$B\$52/365))+((\$B\$26*\$B\$50)*\$B\$54)+(\$B\$26*\$B\$50*(\$B\$55/365)))

regards, barry
0

Project financeAuthor Commented:
OK that does work for a scenario I have but for the other one (wont go into detail) it does not work.  Can you modify to if it equals "Does not Drop Down" then return "Does not Drop Down" and Else the formula?

thank you barry...
0

Project financeAuthor Commented:
that was it!  thank you barry...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.