Help With If Statement

  • Thread starter Thread starter AceWebmaster
  • Start date Start date
A

AceWebmaster

Can anyone explain to me how to correct the following logical expressio
which is designed to compare two columns. If the first column contains
1 (indicating PM time) and if the second column contains an integer les
then 12(after 12 noon) I want to add 12 to the number from the secon
column. This is used to create a 24 hour clock column so that 1:00PM i
13 and 2:00PM is 14.

I31 contains either 0 or 1 (0=AM, 1=PM)
J31 contains hours 0-12

if J31 is 1 then it is a PM hour.

=IF(((I31="1") AND (J31<12)),J31+12,J31)

The problem is that it doesn't like the AND logical expression
 
I think J31 must contain numbers from 0 to 11, not to 12, in which case
the AND is not really required:

=IF(AND(I31=1,J31<=12),J31+12,J31)

can be replaced with:

=IF(I31=1,J31+12,J31)

Hope this helps.

Pete
 
Thanks everyone. The AND logic syntax had me baffled but now
understand the syntax. The expressions worked great. The MOD als
worked great. I appreciate everyones help on resolving this
 
Back
Top