View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jmv
 
Posts: n/a
Default If/And/Or formula


let me try to restate this

if either a1 is greater than zero or a2 is greater than zero and a3 is
zero - then "footnote A"

a1 a2 a3 a4
1 1 0 footnote a
1 0 1 blank
1 1 4 blank
0 1 0 footnote a

Thank you once again for all your help!


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804