Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF then formula
=IF(FIND("X",UPPER(B98))0,IF(SUM($AM98,$AN98)<=0, "X"," "),"")
"keith" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF then formula
Better (supresses error in find):
=IF(NOT(ISERR(FIND("X",UPPER(B98)))),IF(SUM($AM98, $AN98)<=0,"X"," "),"") "keith" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|