Gossamer Forum
Home : General : Internet Technologies :

Re: [ksrhyd] CountIF in Excel

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 4857 Jan 30, 2003, 10:14 AM
Post Re: [ksrhyd] CountIF in Excel
joematt 4655 Feb 5, 2003, 12:32 PM