i need to compare D1 = E1 , formula should be in F1,
if true value comes, then i desired cell should be blank,
if false value comes, then i will like to display "CHECK STATUS"
i need to compare D1 = E1 , formula should be in F1,
if true value comes, then i desired cell should be blank,
if false value comes, then i will like to display "CHECK STATUS"
=if(d1<>e1,"check status" ,"")
Wow its working, thanks a lot, and i have a similar question, pls find this excel and solve this problem also,
compare two COLUMN and display if any numbers in first column and second column is blank then display Desired word,
all others should be blank, pls help us..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks