I am having issues with a formula:
E7=100%
E6=Not Rated
=IF(E7=E6,"",E7-E6)
i know the reason the #VALUE! is because of the N/R, but I am wondering if there is any way to make the solution cell read 100% when this situation arises.
I am having issues with a formula:
E7=100%
E6=Not Rated
=IF(E7=E6,"",E7-E6)
i know the reason the #VALUE! is because of the N/R, but I am wondering if there is any way to make the solution cell read 100% when this situation arises.
Your looking for conditional format.
Excel 2007 => start => conditional format.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Perhaps( I don't think CF can return a value)Please Login or Register to view this content.
E7=100%
E6=Not Rated
=IF(E7=E6,"",E7-E6)
Here is how i got it to work....
=IF(E7=E6,"",IF(ISNUMBER(E7-E6),E7-E6,E7))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks