Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |