=if
New problem.
I wanna make a colum with the IF-parameter that makes this: If the colum shows over 80 but under 160 i want it to show 1.
Anyone?
Hi,
This will return 1 if A1 is between 80 and 160, and if not will return a blank.
=IF(AND(A1>80,A1<160),"1","")
Sarcasm - because beating the **** out of someone is illegal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks