#Value

Closed
Viking57 - Apr 19, 2010 at 11:34 AM
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
- Apr 19, 2010 at 11:11 PM
I have used the following Fomulas, but when I try to use same in newer Excel I get #Value error.

Column D =if(C6=0,"",)
Column E =if(H6=0,"",(C6*H6)-(D6+F6))
Column E Blank
Column G =if((h6*C6)=0,"",(H6*C6))
Column H 0%
Column H =if((C6-D6-E6-F6)=0,"",(C6-D6-E6-F6)) Returns #value!
Column I =if(G6>0,G6*'sheet2'!$C$6,"") Sheet2 C6 is 10% Returns #value!

6 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
Uploaded on speedyshare.com sample pay app
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 19, 2010 at 12:14 PM
I am sorry. I neglected to mention that please post back the link here.
0

Didn't find the answer you are looking for?

Ask a question
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
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,"")
0