Converting Excel formula to a Numbers one

Question

Hello, I’m hoping someone can please help.

I have a duration/time formula from an old Excel spread sheet that I can’t get to work on my Numbers spread sheet.

The Excel formula;

=IF(K31=O31;”On time”;TEXT(ABS(O31-K31);”[mm]:ss“)&IF(K31>O31;”under”;”over”))

This above formula returns a time that is either “over” or “under” an estimated time , example is

10:23under or 01:02over or On time

Holding thumbs....

MacBook Pro, macOS High Sierra (10.13.2)

Posted on May 2, 2018 8:51 AM

Reply

Answer 1

Level 8

37,980 points

If I understand you correctly you can try something like this:

=IF(K31>L31,K31−L31&" under",IF(K31<L31,L31−K31 & " over","ontime"))

Or if your region uses the comma (a ,) as a decimal separator:

=IF(K31>L31;K31−L31&" under";IF(K31<L31;L31−K31 & " over";"ontime"))

Reply

Answer 2

That’s it! Exactly the right one, thank you so much.

Reply

Similar questions