Remember Me?

#1
April 5th 05, 02:37 AM
 sabretooth54 Posts: n/a
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.

#2
April 5th 05, 02:45 AM
 Michael Posts: n/a

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.

#3
April 5th 05, 05:39 AM
 sabretooth54 Posts: n/a

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.

#4
April 5th 05, 05:47 AM
 Michael Posts: n/a

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.

#5
April 5th 05, 12:39 PM
 Dana DeLouis Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post The Window Cleaner Excel Discussion (Misc queries) 0 March 10th 05 11:03 AM Darius Excel Worksheet Functions 5 February 21st 05 11:14 PM unionhall Excel Discussion (Misc queries) 1 February 17th 05 10:10 AM rbc Excel Worksheet Functions 4 January 6th 05 12:21 PM Bob H Excel Worksheet Functions 2 November 30th 04 08:35 PM

All times are GMT +1. The time now is 11:06 PM.