welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,414
- Office Version
- 2019
- 2007
- Platform
- Windows
What is happening?
OK, fairly familiar with Excel.
I have a workbook and in column D I have a formula =IF(AE83=0,"NIL",AE83) for each relevant row.
AE83 has formula of =SUM(E83:AC83)
Basically I am summing the row. When AE is zero I want to show NIL in column D.
This works exactly as intended for most cells. I have conditional formatting to fill as Green for those that show NIL.
Two rows show 0 in column D and then show Red due to the CF.
I've copied cells showing NIL to those errant cells and it make no difference, hence this post.??
TIA

OK, fairly familiar with Excel.
I have a workbook and in column D I have a formula =IF(AE83=0,"NIL",AE83) for each relevant row.
AE83 has formula of =SUM(E83:AC83)
Basically I am summing the row. When AE is zero I want to show NIL in column D.
This works exactly as intended for most cells. I have conditional formatting to fill as Green for those that show NIL.
Two rows show 0 in column D and then show Red due to the CF.
I've copied cells showing NIL to those errant cells and it make no difference, hence this post.??
TIA
