I'm using this IF statement, but I'm still returning a #VALUE! error code. Can you guys let me know what I'm missing?
=IF(AA17="",(Z20+2*Z21)*Variables!$B$13,IF(ISERROR(AA20+1*AA21)*Variables!$B$13,"",(AA20+1*AA21)*Variables!$B$13))
I'm using this IF statement, but I'm still returning a #VALUE! error code. Can you guys let me know what I'm missing?
=IF(AA17="",(Z20+2*Z21)*Variables!$B$13,IF(ISERROR(AA20+1*AA21)*Variables!$B$13,"",(AA20+1*AA21)*Variables!$B$13))
Last edited by snapa; 12-07-2009 at 12:15 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks