Help with an IF

[msja26]

I have a spread sheet I us for pricing thru the month. In cell AD358 I have the following formula that show the last NON-ZERO entry in the row (there will always be some zeros as well as blank cells)<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl23 height=17 width=64 x:str="'=LOOKUP(9.99999999999999E+307,1/E358:AA358,E358:AA358)">=LOOKUP(9.99999999999999E+307,1/E358:AA358,E358:AA358)</TD></TR></TBODY></TABLE>
This has worked great for my needs but now I have been asked to link my data to another sheet. They want to have the price the Item started at, cell C358, or, if it has changed the new price, cell AD358 displayed for their link. I tried to put in =IF($AD358 = "", $C358, $AD358). This works great if a new price is entered but if not, in call AD358 it showes #N/A, which I have never cared about but now I do not know how to set the formula in the "IF" to work. Please help!

 

[Jonmo1]

Try

=IF(ISNA($AD358),"",IF($AD358="",$C358,,$AD358))

That will return a blank "" when AD358 is #N/A

 

[msja26]

thank you very much!!

 

[msja26]

It's telling me I have entered to many arguments for this function

 

[Jonmo1]

I did a typo, put 2 commas instead of 1

=IF(ISNA($AD358),"",IF($AD358="",$C358,,$AD358))

Should be
=IF(ISNA($AD358),"",IF($AD358="",$C358,$AD358))