=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,

=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,

=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,

=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,

=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,

=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,