Logbook

[khalil]

hi all
please help me in this formula

=IF(AND('Fill Info.'!P8=LogBook!$E$1),'Fill Info.'!H8,"")

i want to add another cell from (fill info. sheet) like ('Fill Info.'!N8=LogBook!$E$1)
without creating a conflect.

thanks

 

[Richard Schollar]

Do both P8 AND N8 need to equal E1 for the TRUE condition of the if to be returned? If so then:

=IF(AND('Fill Info.'!P8=LogBook!$E$1,'Fill Info.'!N8=LogBook!$E$1),'Fill Info.'!H8,"")

If only one or other needs to equal E1 then:

=IF(OR('Fill Info.'!P8=LogBook!$E$1,'Fill Info.'!N8=LogBook!$E$1),'Fill Info.'!H8,"")

 

[khalil]

Do both P8 AND N8 need to equal E1 for the TRUE condition of the if to be returned? If so then:

=IF(AND('Fill Info.'!P8=LogBook!$E$1,'Fill Info.'!N8=LogBook!$E$1),'Fill Info.'!H8,"")

If only one or other needs to equal E1 then:

=IF(OR('Fill Info.'!P8=LogBook!$E$1,'Fill Info.'!N8=LogBook!$E$1),'Fill Info.'!H8,"")

thanks Richard

 

[khalil]

Thanks Richard