ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,227
- Office Version
- 2007
- Platform
- Windows
Morning,
My sheet is like so,
Column C Sale Price
Column D P & P
Column E Total Sale Price
The formula on the sheet in Column D is like so & continues down the page.
I enter a value in cell C
When i leave the cell straight away in cell E i i then see #VALUE
This #VALUE text is gone when i then enter a value in cell D
Column E formula is like so & continues down the page.
It would be nice NOT to see the #VALUE every time
My sheet is like so,
Column C Sale Price
Column D P & P
Column E Total Sale Price
The formula on the sheet in Column D is like so & continues down the page.
Rich (BB code):
=IF(AND(LEN(B6)=14,(MID(B6,3,1)&MID(B6,9,1))="--"),0,"")
I enter a value in cell C
When i leave the cell straight away in cell E i i then see #VALUE
This #VALUE text is gone when i then enter a value in cell D
Column E formula is like so & continues down the page.
Rich (BB code):
=IF(C6="","",C6+D6)
It would be nice NOT to see the #VALUE every time