| 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 Try =if(and(D43=45,D43<=87),"5.00","0.00") is this what u need? |
|
#3
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 |
|
#4
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 |
|
#5
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 |
|
#6
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? |
|
#7
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
|
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
I sent if you have any ? you can e-mail me
"Gary" wrote: sure..send it to "Mike" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
I got the file but can u just write in words what u need.
"Mike" wrote in message ... I sent if you have any ? you can e-mail me "Gary" wrote: sure..send it to "Mike" wrote in message ... 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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
Try this. Enter as an array formula Code: -------------------- =IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276)," $75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00")) -------------------- -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=562311 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
Hi MIke, this is what i think u need and hope this would do what u r looking
for. =IF(AND(B43=14.1,B43<=23,D43=45,D43<=87,E43=100 0,E43<=1275),"$75.00",IF(OR(AND(D43=45,D43<=87,E4 3=1000,E43<=1275),AND(B43=14.1,B43<=23,D43=45,D 43<=87)),"$37.5","0.00")) "edwardpestian" wrote in message news:edwardpestian.2b4nr1_1153203304.6836@excelfor um-nospam.com... Try this. Enter as an array formula Code: -------------------- =IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276)," $75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00")) -------------------- -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=562311 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
Sorry, I entered E instead of F
this is working fine now. =IF(AND(B43=14.1,B43<=23,D43=45,D43<=87,F43=100 0,F43<=1275),"$75.00",IF(OR(AND(D43=45,D43<=87,F4 3=1000,F43<=1275),AND(B43=14.1,B43<=23,D43=45,D 43<=87)),"$37.5","0.00")) "Gary" wrote in message ... Hi MIke, this is what i think u need and hope this would do what u r looking for. =IF(AND(B43=14.1,B43<=23,D43=45,D43<=87,E43=100 0,E43<=1275),"$75.00",IF(OR(AND(D43=45,D43<=87,E4 3=1000,E43<=1275),AND(B43=14.1,B43<=23,D43=45,D 43<=87)),"$37.5","0.00")) "edwardpestian" wrote in message news:edwardpestian.2b4nr1_1153203304.6836@excelfor um-nospam.com... Try this. Enter as an array formula Code: -------------------- =IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276)," $75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00")) -------------------- -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=562311 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=IF(D43=45*D43<=87,"5.00","0.00")
"edwardpestian" wrote...
Try this. Enter as an array formula Code: =IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276)," $75.00",IF((B4414)*(B44<24)*(D4444)*(D44<88),"$3 7.50","$0.00")) No need to array enter, just enter normally. I'd be willing to bet a huge amount of money that the OP intends the result to be NUMERIC, so: =IF((B4414)*(B44<24)*(D4444)*(D44<88)*(F44999)* (F44<1276),75,IF((B4414)*(B44<24)*(D4444)*(D44<8 8),37.5,0)) Then just format as CURRENCY 2 decimal places. Biff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
