Excel help with formula
08 May 2012, 06:15 PM
#1
Scooby Regular
Thread Starter
Join Date: Aug 2005
Location: 392/361 MY04 STi
Posts: 7,638
Likes: 0
Received 0 Likes
on
0 Posts
Excel help with formula
If i enter 7,8, or 9 in a cell, i want the cell below to be a 10. Likewise if i enter a 10, i want the cell below to default to 9.
How would i go about doing that?
Yes, it's a boxing scoring spreadsheet
How would i go about doing that?
Yes, it's a boxing scoring spreadsheet
10 May 2012, 07:34 PM
#4
Scooby Regular
iTrader: (1)
Join Date: Aug 2005
Location: Manchester ish
Posts: 18,547
Likes: 0
Received 0 Likes
on
0 Posts
basic example, assuming the first score is in cell a1 for simplicity
in cell b1 you would enter something like =if(a1=10,value if true, value if false)
so it would look like =if(A1=10,9,10)
For your requirements something like =if(A1<10,10,9) which has more scope than the first example should cover your needs
Copy the formula down from cell b1
in cell b1 you would enter something like =if(a1=10,value if true, value if false)
so it would look like =if(A1=10,9,10)
For your requirements something like =if(A1<10,10,9) which has more scope than the first example should cover your needs
Copy the formula down from cell b1
Last edited by jaytc2003; 10 May 2012 at 07:36 PM.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM