MrExcel Publishing
Your One Stop for Excel Tips & Solutions

An 'or' command


Posted by Paul on December 19, 2001 2:43 PM


I'm looking for a way to check 2 places for a 0 (zero).

The command I'm using is:

=IF(B47=0,k43,b47/a47)

I want it to check A47 also for a zero

Like an 'or' cpmmand in basic.

I'm using Excel V5.0 - 1993 edition

Thanks,
Paul


Posted by Qroozn on December 19, 2001 2:48 PM

here it is

=IF(OR(b47=0,a47=0),k43,b47/a47)

HO HO HO

Posted by Aladin Akyurek on December 19, 2001 3:11 PM

Paul --

How about

=IF(B47,B47/MAX(1,A47),K43)

Aladin

=========