This formula wont display a result, and will have #VALUE when other boxes are clear. I have similar formula working everywhere else, except this one?
I want the cells to look blank when there is nothing to add.
this is what i'm trying.
Formula:
Please Login or Register to view this content.
This is the original formula:
Formula:Please Login or Register to view this content.
Thanks
To make that work with ISERROR try
=IF(ISERROR((T6*$Z$7)+(U6*$Z$7)),"",(T6*$Z$7)+(U6*$Z$7))
but in Excel 2007 you can use IFERROR like this
=IFERROR((T6*$Z$7)+(U6*$Z$7),"")
or even....
=IFERROR((T6+U6)*$Z$7,"")
Audere est facere
You appear to be missing a pair of brackets:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Doh! Haha, thanks, works now!
But I'll keep the others in mind also!
Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks