ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
I'm trying to use the Rank function with if statement but without success.
Here is the formula:
=IF(OR(BF36="Tea",BF36="Cho"),"ignore",RANK(BE36,$BE$9:$BE$486,1))
Any help fixing the formula would be great, thanks.
Here is the formula:
=IF(OR(BF36="Tea",BF36="Cho"),"ignore",RANK(BE36,$BE$9:$BE$486,1))
Any help fixing the formula would be great, thanks.