#Value
Closed
Viking57
-
Apr 19, 2010 at 11:34 AM
kaiyasit
kaiyasit
- Posts
- 30
- Registration date
- Sunday August 9, 2009
- Status
- Member
- Last seen
- April 20, 2010
Related:
- Based on the value in cells b77
- Based on the values in cells b77 b81 - Best answers
- Based on the values in cells b77 - Best answers
- Based on the values in cells b77 b81 ✓ - Forum - Excel
- Based on the values in cells b77 b81 which function can automatically return the value in cell 77 ✓ - Forum - Excel
- Conversion of values already present in cells ✓ - Forum - Excel
- Fixing populating values into textboxes based on showing data in listbox ✓ - Forum - Excel
- Find values based on colum and sum in a table - Forum - Office Software
6 replies
rizvisa1
Apr 19, 2010 at 11:52 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 19, 2010 at 11:52 AM
Could you please upload a sample file on some shared site like https://authentification.site It would be possible to tell you why this is happening
rizvisa1
Apr 19, 2010 at 12:14 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 19, 2010 at 12:14 PM
I am sorry. I neglected to mention that please post back the link here.
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Apr 19, 2010 at 12:46 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Apr 19, 2010 at 12:46 PM
Try this
Column H
=IF((IF(C6="",0,C6)-IF(D6="",0,D6)-IF(E6="",0,E6)-IF(F6="",0,F6))=0,"",(IF(C6="",0,C6)-IF(D6="",0,D6)-IF(E6="",0,E6)-IF(F6="",0,F6)))
Column I
=if(IF(G6="",0,G6)>0,G6*'sheet2'!$C$6,"")
blank cells value were messing up your formula
Column H
=IF((IF(C6="",0,C6)-IF(D6="",0,D6)-IF(E6="",0,E6)-IF(F6="",0,F6))=0,"",(IF(C6="",0,C6)-IF(D6="",0,D6)-IF(E6="",0,E6)-IF(F6="",0,F6)))
Column I
=if(IF(G6="",0,G6)>0,G6*'sheet2'!$C$6,"")
blank cells value were messing up your formula
kaiyasit
Apr 19, 2010 at 11:11 PM
- Posts
- 30
- Registration date
- Sunday August 9, 2009
- Status
- Member
- Last seen
- April 20, 2010
Apr 19, 2010 at 11:11 PM
You can use ISERROR function to prevent this error
=IF(ISERROR(C12-D12-E12-F12),"",IF((C12-D12-E12-F12)=0,"",(C12-D12-E12-F12)))
or arrange you formula again
=IF(C10-D10-E10-F10<>0,C10-D10-E10-F10,"")
=IF(ISERROR(C12-D12-E12-F12),"",IF((C12-D12-E12-F12)=0,"",(C12-D12-E12-F12)))
or arrange you formula again
=IF(C10-D10-E10-F10<>0,C10-D10-E10-F10,"")