Conditional formatting

excel 2003 , formulas , conditions Manchester, United Kingdom
  • 10 years ago
    Hi Hope you can help I am using Excel 2003 and I have In cell A3 the number of contracted hours for staff member I need in cell A4 a formula which shows the following - if hours are less than 10 it needs to show the code - IND if hours are equal to 10 - code - PA if hours are more than 10 - code APA Thanks Peter

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil perpetrated by skilled but perverted professionals.” - Jon Ribbens