LinkBack URL
About LinkBacks
I need help with writing a formula that gives a cell a value based on two requirements. For example i want cell A2 to = 1 if cell B2's value is >50 but <60.
I need help with writing a formula that gives a cell a value based on two requirements. For example i want cell A2 to = 1 if cell B2's value is >50 but <60.
Last edited by mdovey; 10-25-2013 at 05:29 PM.
Put this formula in cell A2: =IF(AND(B2>50,B2<60),1,"")
Thank you very much
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks