need help with a formula in excel
 

trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.

Hi
What happens when A1 =1 ??
I have allowed for this in the formula below by having A1 <= to 1
Put this in B1
=IF(A11,A1-1,IF(A1<=1,0,""))

HTH
Michael

"sabretooth54" wrote:

trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.

Hi
If A1=1, the result could either be 1 or 0.5. I haven't figured out how I
am going to deal with this yet, but the formula you gave me works great.
Thank you Michael!

"Michael" wrote:

Hi
What happens when A1 =1 ??
I have allowed for this in the formula below by having A1 <= to 1
Put this in B1
=IF(A11,A1-1,IF(A1<=1,0,""))

HTH
Michael

"sabretooth54" wrote:

trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.

Keep in mind that you can use up to 7 IF statements.
If you post what you want A1=1 to do, I'm sure there will be plenty of
solutions
And thank you for the feedback

HTH
Michael

"sabretooth54" wrote:

Hi
If A1=1, the result could either be 1 or 0.5. I haven't figured out how I
am going to deal with this yet, but the formula you gave me works great.
Thank you Michael!

"Michael" wrote:

Hi
What happens when A1 =1 ??
I have allowed for this in the formula below by having A1 <= to 1
Put this in B1
=IF(A11,A1-1,IF(A1<=1,0,""))

HTH
Michael

"sabretooth54" wrote:

trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.

Not sure, but would this work?

=MAX(A1-1,0)

--
Dana DeLouis
Win XP & Office 2003


"sabretooth54" wrote in message
...
Hi
If A1=1, the result could either be 1 or 0.5. I haven't figured out how I
am going to deal with this yet, but the formula you gave me works great.
Thank you Michael!

"Michael" wrote:

Hi
What happens when A1 =1 ??
I have allowed for this in the formula below by having A1 <= to 1
Put this in B1
=IF(A11,A1-1,IF(A1<=1,0,""))

HTH
Michael

"sabretooth54" wrote:

trying to create this formula: if a1 is greater than 1 then b1 will
equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero.