View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sferguson sferguson is offline
external usenet poster
 
Posts: 10
Default More Help Needed!

Okay - now I have a formula that looks like this:

=IF(AH2=FALSE,0,-1)

This is working fine, but now I need it to do more. What I'm trying to do
is look at AH2 and if it says FALSE still return the 0 and if it says TRUE
return a -1 UNLESS cell B2 has a 0 in it - if cell B2 has a 0 in it and AH2
says TRUE, then I need it to return a 0.

Anyone have any ideas? Thanks for your help!