Gossamer Forum
(Advanced Search)
for
Home : General : Internet Technologies :

Re: [ksrhyd] CountIF in Excel

Feb 5, 2003, 12:32 PM
joematt
User (287 posts)
Feb 5, 2003, 12:32 PM
Views: 5094
Shortcut
Quote Reply
Re: [ksrhyd] CountIF in Excel In reply to
try something like this..

=IF(A1=0,IF(B1=0,"both zero","first zero not both zero"),"not both zero")


this is a typical nested if, you can nest to your heart's content.
Subject Author Views Date
Thread CountIF in Excel ksrhyd 5313 Jan 30, 2003, 10:14 AM
Post Re: [ksrhyd] CountIF in Excel 		joematt 5094 Feb 5, 2003, 12:32 PM