Hi,
Okay, so:
A1 displays "127:15" (no quotes, text cell).
A2 has the function MID(A1,1,3), to retrieve the number "127".
A3 has the function IF(A2>186,"yes","no").
A3 says: yes.
Why?
Thank you all!![]()
Hi,
Okay, so:
A1 displays "127:15" (no quotes, text cell).
A2 has the function MID(A1,1,3), to retrieve the number "127".
A3 has the function IF(A2>186,"yes","no").
A3 says: yes.
Why?
Thank you all!![]()
Last edited by blackmilk; 04-12-2010 at 11:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks