dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
Basically if the value in a cell exceeds 2500 i want it to cancel back down to 2500 and show up red.
Can this be done... please note it will go into said sell via another formula so it will come up as 2,801.33 i want it to then go to 2,500 and show up red.
Cheers 
If it can be done, how?
[Edited on 28-10-2005 by dna23]
|
Jamie Walby
Member
Registered: 15th Nov 04
User status: Offline
|
Yes
   
|
dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
quote:
Originally posted by Jamie Walby
Yes
how?
|
Melville
Member
Registered: 4th Jun 03
Location: Newcastle upon Tyne
User status: Offline
|
to turn it red you need to use conditional formating. There are a number of ways to do the round down method but I would have to see your spread sheet. Use =rounddown(*cells and formula*,deciamal spaces ie 0)
|
dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
i know the conditional formatting part for the red its the 2500...
i tried using Data>>>Validation>>Allow then decimel between 0 and 2500 but it doesnt work for a calculation only a direct input value
i'll try out ure method mate
|
Melville
Member
Registered: 4th Jun 03
Location: Newcastle upon Tyne
User status: Offline
|
Actually thats wrong, sorry
You will need to use IF forumala...
=IF(C23>2500,2500,C23)
|
dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
quote:
Originally posted by Melville
Actually thats wrong, sorry
You will need to use IF forumala...
=IF(C23>2500,2500,C23)
u fucking legend
will this then carry on though as it being 2500 if i use that cell in a formula again...
so the cell value= G7*H$5% but if it is say 2900 it will go to 2500 so in the cell next to it i have C23/C22 or watever  will it take C23 as 2900 or 2500
[Edited on 28-10-2005 by dna23]
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
I work with these kind of formulas all day.
|
dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
quote:
Originally posted by Ojc
I work with these kind of formulas all day.
thats nice ollie, so hopefully you can answer some of the questions i asked 
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
That one was to complex? I normally can only work things out when the spreadsheet is in front of me.
Do you do lookups? I amaze people with my skill with lookups.
That bird you u2u'ed me with, shes left my work now but we are still very good friends, I am going to the cinema with her on Monday in my Coupe.
|
dna23
Member
Registered: 1st Nov 04
Location: Northamptonshire
User status: Offline
|
cool, can i sit in the back and ride shotgun?
it's not complex but u have to see the rest of the spreadsheet oliver... it's ever so intricate
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
Pivot tables and all sorts 
|
