主题：请问关于最大值筛选问题

版主好：我想在“会员类型”列，根据顾客充值的最大值确定其类型，有“会员卡”，“ 金卡”，“ 贵宾卡”，“非会员”类别。怎么下面的公式不正确呢？请帮忙检查，感谢！

if(if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 100,"会员卡",if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 200,"金卡",if(MaxFor("收银系统","本次充值金额","卡号"," = ",[卡号]) >= 500,"贵宾卡", "非会员" ))))