=IF formula between numbers

[bigmacneb]

I'm trying to accomplish this - I have a range of numbers anywhere between .925 and 1 in D2, D4, D6.... I'm going to subtract .005 from this number, however if the number is .925 I don't want it to subtract the .005.
Any ideas?

 

[Tazguy37]

You could use something like:

=IF(D2>0.925,D2-0.005,D2)

HTH

 

[tactps]

how about:
=if(d2=0.925,0.925,d2-0.005)

or if you want to subtract, but use 0.925 as the minimum result:
=max(0.925,d2-0.005)

 

[bigmacneb]

one other caveat if D2=1 then I want it to say "Check"

 

[tactps]

how about:
=if(d2=1,"check",if(d2=0.925,0.925,d2-0.005))

or if you want to subtract, but use 0.925 as the minimum result:
=if(D2=1,"Check",max(0.925,d2-0.005))

 

[bigmacneb]

tactps, or anyone. The formula "=if(d2=1,"check",if(d2=0.925,0.925,d2-0.005))" worked perfectly. however I have one caveat that I need some assistance with.

I need to add to that formula that if d2=.9275 i need it to subtract .0025.
Possible?
suggestions?
thanks guys and gals.

 

[just_jon]

What do you want to do with .929?

 

[bigmacneb]

There never should be a .929. It will always be a 1/4 of a percent. so .9275 or .93 or .9325 etc.

 

[just_jon]

tactps, or anyone. The formula "=if(d2=1,"check",if(d2=0.925,0.925,d2-0.005))" worked perfectly. however I have one caveat that I need some assistance with.

I need to add to that formula that if d2=.9275 i need it to subtract .0025.
Possible?
suggestions?
thanks guys and gals.

=if(d2=1,"check",if(d2=0.925,D2,IF(D2=0.9275,D2-.0025,,d2-0.005)))

 

[Seti]

Jon,

A stray comma I think.

=if(d2=1,"check",if(d2=0.925,D2,IF(D2=0.9275,D2-.0025,d2-0.005)))

bigmacneb,

It looks like you never want a value less than .925, so maybe this:

=if(d2=1,"check",max(.925,D2-.005))