Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Gary,
This works for but could i e-mail you my sheet and you may understand better than i can explain it "Biff" wrote: "Mike" wrote... That work and i thought i could finsh the restbut can't could you look at this please =IF(B4414*B44<24*D4444*D44<88*F44999*F44<1276," $75.00",IF(B4414*B44<24*D4444*D44<88,"$37.50","$ 0.00")) Try this: =IF(AND(B4414,B44<24,D4444,D44<88,F44999,F44<12 76),75,IF(AND(B4414,B44<24,D4444,D44<88),37.5,0) ) Biff |