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. |
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. |
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. |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com