Previous Topic Next Topic

#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

Answer 1 / 6
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
Answer 2 / 6
Viking57
Apr 19, 2010 at 12:02 PM
Uploaded on speedyshare.com sample pay app
Answer 3 / 6
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.
Answer 4 / 6
Viking57
Apr 19, 2010 at 12:19 PM
https://authentification.site/files/22023326/Sample_Pay_App.xls
Answer 5 / 6
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
Answer 6 / 6
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,"")