# #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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Uploaded on speedyshare.com sample pay app
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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?

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
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,"")