Previous Topic Next Topic

#Value

Closed
Viking57 - 19 Apr 2010 à 11:34
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 - 19 Apr 2010 à 23:11
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

Réponse 1 / 6
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Apr 2010 à 11:52
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
Réponse 2 / 6
Viking57
19 Apr 2010 à 12:02
Uploaded on speedyshare.com sample pay app
Réponse 3 / 6
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Apr 2010 à 12:14
I am sorry. I neglected to mention that please post back the link here.
Réponse 4 / 6
Viking57
19 Apr 2010 à 12:19
https://authentification.site/files/22023326/Sample_Pay_App.xls
Réponse 5 / 6
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Apr 2010 à 12:46
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
Réponse 6 / 6
kaiyasit Posts 30 Registration date Sunday 9 August 2009 Status Member Last seen 20 April 2010 12
19 Apr 2010 à 23:11
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,"")