| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF(D43=45*D43<=87,"5.00","0.00")
I'm trying to get a formula to be between two numbers. Is my * my problem
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
"Mike" wrote in message
... I'm trying to get a formula to be between two numbers. Is my * my problem =IF(D43=45*D43<=87,"5.00","0.00") Try this: =AND(D43=45,D43<=87)*5 Format as NUMBER 2 decimal places Biff |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
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")) "Biff" wrote: "Mike" wrote in message ... I'm trying to get a formula to be between two numbers. Is my * my problem =IF(D43=45*D43<=87,"5.00","0.00") Try this: =AND(D43=45,D43<=87)*5 Format as NUMBER 2 decimal places Biff |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
"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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
Mike" wrote in message
... I'm trying to get a formula to be between two numbers. Is my * my problem Try =if(and(D43=45,D43<=87),"5.00","0.00") is this what u need? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
Gary,
this works but need to and two more cells and ranges to this formula could this be done "Gary" wrote: Mike" wrote in message ... I'm trying to get a formula to be between two numbers. Is my * my problem Try =if(and(D43=45,D43<=87),"5.00","0.00") is this what u need? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
