Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Hello All,
Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Not sure what you mean. Maybe this:
=IF(L3517=0,"",IF(E3517="SEARS",L3517,(ROUND(-L3517*0.01,2))+L3517)) HTH, Paul -- "Susan" wrote in message ... Hello All, Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
This should do what you want...
=IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2)))+L3517 Rick "Susan" wrote in message ... Hello All, Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Rick,
I think you'll need to do it like this: =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2))+L3517) otherwise you'll be trying to add a number onto " " when L3517 is zero. Pete "Rick Rothstein (MVP - VB)" wrote in message ... This should do what you want... =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2)))+L3517 Rick "Susan" wrote in message ... Hello All, Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Good point!
Rick "Pete_UK" wrote in message ... Rick, I think you'll need to do it like this: =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2))+L3517) otherwise you'll be trying to add a number onto " " when L3517 is zero. Pete "Rick Rothstein (MVP - VB)" wrote in message ... This should do what you want... =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2)))+L3517 Rick "Susan" wrote in message ... Hello All, Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
Thank you Rick, Pete and Paul
You guys are the best! "Rick Rothstein (MVP - VB)" wrote: Good point! Rick "Pete_UK" wrote in message ... Rick, I think you'll need to do it like this: =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2))+L3517) otherwise you'll be trying to add a number onto " " when L3517 is zero. Pete "Rick Rothstein (MVP - VB)" wrote in message ... This should do what you want... =IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2)))+L3517 Rick "Susan" wrote in message ... Hello All, Having trouble adding criteria to an IF function. Using in Cell S3517: =IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517. Need to add: IF "SEARS" apprears in E3517, disregard other criteria and put the amount from cell L3517, with no 1% discount and no rounding, in cell S3517. Is this possible? Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|