Originally Posted by Ryanoo

Hello,

I hope you are all well and this is in the correct section.


I have a problem with an IF command.

-------------------------------------------------------------------------------
Details;

-EXCEL 2010

-All cells containing times are custom formatted to show hh:mm

A1 - IF formula.
B1 - Contains a formula that displays an average time for a range of cells.
C1 - Contains [=now] for current time.

-----------------------------------------------------------------------------------

Basically I would like A1 to check if the current time (c1) is later than B1.
If the argument is true (if C1 is later than B1) it should return Available?
If it is false (not later) then it should return un-available.


Thanks in advance,
Ryan.