Thread: IF then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keith keith is offline
external usenet poster
 
Posts: 1
Default IF then formula

Im working on a formula that I need to do the following:

Look at cell B98 and if that cell has a "X" in it do the
following.

Add cells AM98+AN98 if the total is 0 or less put a X in
the Cell.

I think that I'm close.

=IF B97=X then(SUM($AM98+$AN98<=0),"X"," "))

Thanks for any Help
Keith.