I need an IF formula for if a cell is equal to another cell and that cell contains a value, so for example if my formula was =IF(G3=J3,1,2), how could i change that so it only works when my cells are not blank.
I need an IF formula for if a cell is equal to another cell and that cell contains a value, so for example if my formula was =IF(G3=J3,1,2), how could i change that so it only works when my cells are not blank.
Last edited by liamfrancis2013; 01-07-2016 at 10:56 AM.
Which is cell is not blank??? can you upload sample spreadsheet with desired result.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
without an answer to Ankur's question, maybe one of these will help...
=IF(OR(G3="",J3=""),"",IF(G3=J3,1,2)) OR
=IF(AND(G3="",J3=""),"",IF(G3=J3,1,2))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
=if(counta(g3,j3)=2,if(g3=j3,1,2),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for the replies ended up going for the nested if: =IF(G2=" "," ",IF(G2=L2,1," ")) which solved the problem
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks