IF statement problem in Excel 97 1

[Cowboysooner]

Are the logical tests in excel 97 limited to numeric fields only? The following IF statements produce a FALSE result but field A4 does equal Audit and A5 does equal Compiled.

1 A B C D
2 Date Last Date Next
3 Document Frequency Received Due
4 Audit Annually 12/31/01 =IF(A4=Audit,C4+515)
5 Compiled Annually 12/31/01 =IF(A5=Compiled,C5+485)

Audited statements are due 515 days from last receipt, compiled statements are due 485 days from last receipt.

 

[LSTAN]

Hi

Try changing

=IF(A4=Audit,C4+515)

to

=IF(A4="Audit",C4+515)

Hope this helps.

rgrds
LSTAN

 

[Cowboysooner]

That works. Thanks for your help.

 

[DaleWatson123321]

Baffelgab,

Pssssssssssst... you "forgot to issue a STAR".

Actually I see from your profile that you're not yet aware of this "accepted practice" of showing "proper" recognition and thanks for the contributor having taken time out of their busy schedule to develop a solution for you.

Issuing a STAR is simply a matter of clicking on the "Click here to mark this post as a helpful or expert post!" - located in the lower-left-corner of the contributor's posting.

I'm told these STARS also serve as "beacons" for other Tek-Tips "browsers" who are "on the lookout" for solutions to similar problems, or just want to build up a "library" of useful solutions.

PLEASE do NOT issue a star for this "reminder". I want to earn stars in the normal way. Thanks.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca