If istext do something if not do something else

[dontstress3]

I have googled this and perhaps I am just missing something simple.
I have three columns, one that tells me the action, one that tells me a deadline and one to give me the due date.
I have one particular cell under deadline that says "Step 1 + 30 days if no XYZ or request for ABC, or Step 1 + 90 days if XYZ or request for ABC"
XYZ is cell E8 and ABC is E3, step 1 is E2
The formula I have been trying is:
=IF(OR(E8=ISTEXT,E2+90,E3=ISTEXT,E2+90),E2+30)
I have also tried
=IF(ISTEXT(OR(E8,E2+90,E3,E2+90)),E2+30)
However, both have errors, is there a link I can read up on, or something I am missing?
I looked at 'if then' for excel, for example this site:
https://blog.udemy.com/excel-if-then/
And nesting excel functions.
Thanks in advance.

[Jonmo1]

Try

=E2+IF(OR(ISTEXT(E8),ISTEXT(E3)),90,30)

[Special-K]

Try

=E2+IF(AND(E8="",E3=""),30,90)

[FDibbins]

Hi, welcome to the forum

Perhaps this (untested)?
=E2+if(or(E8<>"xyz",E3<>"ABC),30,90)

Your description is a little confusing (for me, anyway), so If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[dontstress3]

Try

=E2+IF(OR(ISTEXT(E8),ISTEXT(E3)),90,30)

This worked, I had typed out a long reply but I followed your logic for same issue but different cell:
=E3+IF(ISTEXT(E4)),40,20)
Basically, Step 2 + 20 days, or Step 2 + 40 days, if Step 3.
Step 2 is E3 and Step 3 is E4
So I wanted it to add 40 days if there is text in E4 and if there is not, just add 20.
Thanks so much!

[Jonmo1]

You've got an extra ) in there

=E3+IF(ISTEXT(E4)),40,20)


It helps to count the (
Then count the )
They should both be the same.

[dontstress3]

You've got an extra ) in there

=E3+IF(ISTEXT(E4)),40,20)


It helps to count the (
Then count the )
They should both be the same.

This throws up an error as well, there is text in e4 and in e2 but I want it to add the 40 because there is text in e4, however Excel just says there's an error.

[Jonmo1]

I didn't post a 'corrected' version of your formula.
I only highlighted the error in red.

The 'corrected' version would be
=E3+IF(ISTEXT(E4),40,20)

[dontstress3]

I didn't post a 'corrected' version of your formula.
I only highlighted the error in red.

The 'corrected' version would be
=E3+IF(ISTEXT(E4),40,20)

Thanks, its only adding the 20, if I add text to E4 it does not add 40.
Thanks so much!

[Jonmo1]

Works for me.

Can you post a sample book?
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic