IF function EXCEL - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » IF function EXCEL

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Jas

Member

Registered: 13th Oct 04
Location: Mid Wales
User status: Offline

16th May 12 at 08:25

can't remember.

but looking to flag up any number over 30 etc

for example;

we have a list of reports with driver speeds

we want to have three colums.. 30,60,70mph

and we want to flag if the number exceeds each speed bracket

any help appreciated

Bissmire

Member

Registered: 30th Sep 08
User status: Offline

16th May 12 at 08:32

Would conditional formatting not do the job? Highlight them a certain colour etc?

Whittie

Member

Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline

16th May 12 at 08:36

Select all the Total cells and go to Format / Conditional Formatting

Select Cell Value Is / Less than or Equal to / and enter: =-30

Click Format and choose from the Pattern tab.

Bissmire

Member

Registered: 30th Sep 08
User status: Offline

16th May 12 at 08:38

Never thought of that

Jas

Member

Registered: 13th Oct 04
Location: Mid Wales
User status: Offline

16th May 12 at 08:45

=IF(K4>30,"Over 30MPH"," ")

Jas

Member

Registered: 13th Oct 04
Location: Mid Wales
User status: Offline

16th May 12 at 08:46

Only just seen your reply alex...

They only problem is.. they need to have 3 separate columns >30 >60 >70

anyway off adding a colour to my above formula?

Jas

Member

Registered: 13th Oct 04
Location: Mid Wales
User status: Offline

16th May 12 at 08:47

quote:
Originally posted by Bissmire
Would conditional formatting not do the job? Highlight them a certain colour etc? [/quote

Not really mate as they need over 30 / 60 and 70