I want to create an if statement that says:
If G2 is less than or equal to 1:00 PM then return "Acceptable" and if it is
greater than 1:00 PM return "Not Acceptable"
Thanks for the help!
I want to create an if statement that says:
If G2 is less than or equal to 1:00 PM then return "Acceptable" and if it is
greater than 1:00 PM return "Not Acceptable"
Thanks for the help!
=IF(G2<=TIME(13,0,0),"Acceptable","Not Acceptable")
"JB" wrote:
> I want to create an if statement that says:
>
> If G2 is less than or equal to 1:00 PM then return "Acceptable" and if it is
> greater than 1:00 PM return "Not Acceptable"
>
> Thanks for the help!
>
>
Try
=IF(G2-INT(G2)<=TIME(13,0,0),"Acceptable","Not Acceptable")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"JB" <[email protected]> wrote in message
news:[email protected]...
>I want to create an if statement that says:
>
> If G2 is less than or equal to 1:00 PM then return "Acceptable"
> and if it is
> greater than 1:00 PM return "Not Acceptable"
>
> Thanks for the help!
>
>
Thanks!
"Toppers" wrote:
> =IF(G2<=TIME(13,0,0),"Acceptable","Not Acceptable")
>
> "JB" wrote:
>
> > I want to create an if statement that says:
> >
> > If G2 is less than or equal to 1:00 PM then return "Acceptable" and if it is
> > greater than 1:00 PM return "Not Acceptable"
> >
> > Thanks for the help!
> >
> >
Be aware that if the cell contains a date and time, but is
formatted to display only time, the formula will always return
"Not Acceptable".
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Toppers" <[email protected]> wrote in message
news:[email protected]...
> =IF(G2<=TIME(13,0,0),"Acceptable","Not Acceptable")
>
> "JB" wrote:
>
>> I want to create an if statement that says:
>>
>> If G2 is less than or equal to 1:00 PM then return
>> "Acceptable" and if it is
>> greater than 1:00 PM return "Not Acceptable"
>>
>> Thanks for the help!
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks