Writing 2 formulas within one cell

[yelmoujahid]

Hello!

I am trying to write 2 formulas within 1 cell. I have used the comma to separate, but continuously get an error message. I am using dates to calculate the time it takes to complete a work order: =sum(e562-d562)

However, for those work orders that are not completed yet, I need a specific number '8' to be in that column.

I have tried this:
=sum(e562-d562),=orif(e562="","8") This returns an error. If I delete the comma, it gives me a #NAME? error. I am so confused now! I need it to say:

the difference of e562-d562, or if there is nothing in e562 return an answer of 8.

Please and Thank You in Advance for any help!

[ELeGault]

You do OR first for or statements...

=OR(LogicA,LogicB)
Which can be used inside of other logic statements -


Now that is not what you need here...

You need

Please Login or Register  to view this content.

Which says, If the contents of E562 is equal to "" than display 8, otherwise if it is Not "" than display the difference of E562-D562

[FDibbins]

Post #2 is what you need.

However, to explain how/when OR would be used in your question...

You want to test to see if work orders that are completed, and lets also add in, the WO value has to be over $500...if not, then return the number '8' to be in that column.

That would look like this...
=IF(AND(e562<>"",e562-d562>500),e562-d562,8)
This is testing to make sure that E is not empty AND that E-D is > 500

You could replace the AND with OR if you needed either of those to be true, rather than both needing to be true

[yelmoujahid]

Thank you so much! It worked!