# =IF formula between numbers

#### bigmacneb

##### Board Regular
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?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
You could use something like:

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

HTH

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

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

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

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.

What do you want to do with .929?

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

bigmacneb said:
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)))

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))

Replies
14
Views
321
Replies
2
Views
442
Replies
1
Views
90
Replies
1
Views
69
Replies
8
Views
163

1,203,203
Messages
6,054,099
Members
444,702
Latest member
patrickmg17

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back