I tried using the formula =IF(OR(U3="",V3=""),"",(V3-U3)/U3) but I am still getting the error. I was thinking that it's really not blank since I have the columns formatted to be "Accounting" I tried to add "$ -" that didn't work then I tried to change the format to currency and the IF to "$0.00" but that didn't work either.
Formatting is a cosmetic application to a cell, it does not (generally) affect the cell contents.
Is U3 a manual entry, or a formula? If it is a formula, what is that formula? I have a feeling that if it is a formula, it isa returning something like " " (note the space between the "s)
The reason for #DIV/0 would be because U3 contains no vlaue
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
U3 is a formula =T3/3 and cell V3 is a value. I know why I am getting the error that is why I am trying to modify the formula with IF/OR. The cells in column U and V either have a dollar value or $ - when the amount is zero dollars. I am asking for help with the formula so I do not get the #DIV/0 error in cells that have $ - .
I solved this myself. Even though the cell show $ - if you click in the cell it shows 0 in the formula box so I changed the formula to =IF(OR(U2=0, V2=0),0,(V2-U2)/U2) and it works. Thanks for your input.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks