Returning a blank instead of a 0 and 1 other question
I have an excel question.
In the attached file, I have a formula to return the abs value of H8-G8.
I would like to not see the 0 when there is no data in H8 or G8.
Then I have a formula in K7 that I believe I have set up correctly?
I want it to show the Green check mark when the value of I7 is < 0.135,
and a Red X when the value of I7 is > 0.135, but I want it to show nothing
when there is not a value in cell I7.
Please help!
Change the first formula to =IF(ABS(H8-G8)=0,"",ABS(H8-G8)) and the second to =IF(I7="","",IF(I7<0.135,0,IF(I7>0.135, 2,1)))
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Thank you Darkyam, worked great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks