Convert a Sum into a Word

[Danster2]

I am trying to convert a sum into words eg: U2-AB2 which results in -1 it refers to an appointment being completed and the -1 means its been completed Late. How do I then turn this sum into the word LATE,EARLY or ONTIME.

 

[jeffreybrown]

Hello & Welcome to the Board...

Something like this...

=LOOKUP(SIGN(U2-AB2),{-1,0,1},{"LATE","EARLY","ONTIME"})

You may have to adjust based on your actual requirements

 

[JamesW]

Hi,

Welcome to the board. Try:

=IF(A11<0,"Late",IF(A11>0,"Early","On Time"))

Where A2 is your SUM result.

 

[Weaver]

Welcome to the board!

You have 3 condtions. What are the respective results for each condition?

Obviously, we have -1 for late

Can I assume it's 0 for on time and 1 for early?

If so

=lookup(U2-AB2,{-1,0,1},{"Late","On Time","Early"})