Mr Krayzie
New Member
- Joined
- Feb 22, 2002
- Messages
- 8
Sorry forthis I'm new to excel and hope someone can help me.
Problem: 2 columns of numbers/
I need all the numbers above the value of 500
to have 500 taken off and a U added to them.
I have managed it but it means having to have not just the two original colums but four more.
below is an exmaple of what i want.
A B C D
576 674 to 76U 174U
128 496 to 128 128
364 222 364 222
971 777 471U 277U
Problem: 2 columns of numbers/
I need all the numbers above the value of 500
to have 500 taken off and a U added to them.
I have managed it but it means having to have not just the two original colums but four more.
below is an exmaple of what i want.
A B C D
576 674 to 76U 174U
128 496 to 128 128
364 222 364 222
971 777 471U 277U