Hello
Can i include more colum in this function =OM(B2>80;1;2)?
=IF -----|------
I would like to do so that i could include like this ex: =OM(B2,B3,B4,B5>80;1,2).
If anyone knows, please wright
Hello
Can i include more colum in this function =OM(B2>80;1;2)?
=IF -----|------
I would like to do so that i could include like this ex: =OM(B2,B3,B4,B5>80;1,2).
If anyone knows, please wright
Try
=IF(AND(B2>80,B3>80,B4>80,B5>80),1,2)
you may have to change semicolons for commas
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks