Forum Discussion

Copper Contributor

Jul 06, 2021

Solved

Days Forumla Help

Good day all 🙂 I have tried so many variations and I just can't get it to work....I'm sure I'm overthinking it...LOL I have a spreadsheet I created to track our service calls and when they ...

Formulas and Functions

Lorenzo
Jul 06, 2021
Hannah_Allen
One way:
=IF(AND(ISNUMBER(AE3),ISNUMBER(AI3)), AI3-AE3, "")

Lorenzo

Silver Contributor

Jul 06, 2021

Hannah_Allen

One way:

=IF(AND(ISNUMBER(AE3),ISNUMBER(AI3)), AI3-AE3, "")

Hannah_Allen

Copper Contributor

Jul 06, 2021

OMG I think that one worked!!!! It gives me blanks instead of 0 but that is OK!!

Thank you
Thank you
Thank you!!!

Next one might be a bit more difficult .... but again, I could also be overthinking ... hahaha....new thread / question coming 🙂

Lorenzo
Silver Contributor
Jul 06, 2021
You're welcome. You can change the "" with 0 or anything else. I suggested "" in case you would want to do i.e. an average on the column where you enter the formula
- Hannah_Allen
  Copper Contributor
  Jul 06, 2021
  thank you!!