#VALUE! Error message with IF statment

[n_lindsey]

Hi.

I am using a nested IF statement but continue to get an error message when there is no value in column O. The function is:

=IF(N420=0,G420,IF(N420>0,N420*O420,0))

I also tried the IFERROR which was an epic fail. Is there another function that I need to nest to make this one work?

Thanks.

[FDibbins]

assuming that you are working with data in row 420, try this...

=IF(N420="",G420,IF(N420>0,N420*O420,0))

[kvsrinivasamurthy]

The following should work ,

Please Login or Register  to view this content.

If not try this,

Please Login or Register  to view this content.

[n_lindsey]

Thanks FDibbins and kvsrinivasamurthy. =IF(N420="",G420,IF(N420>0,N420*O420,0)) returns a result of zero when there is a value in column N which is not the result needed. =IFERROR(IF(N420=0,G420,IF(N420>0,N420*O420,0)),"") worked perfectly.

Thank you! Gracias! Merci!

[vlady]

=if(n420=0,g420,if(n420>0,n420*o420,0))

Please Login or Register  to view this content.