l1011driver
Board Regular
- Joined
- Dec 26, 2014
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
Thank you in advance for any help. I'm a novice so no help is too remedial for me.
I have a worksheet in which I'd like to format a cell such that the number entered is formatted based on the input value.
If the entered value is between 2500 and 3500 I would like for Excel to return that number with a decimal inserted to two decimal places. For example, if I enter "3015" I'd like Excel to return the value "30.15". If I enter "3000" I'd like Excel to return the value "30.00" (as opposed to "30").
If the entered value is between 700 and 1500 I would like for Excel to return that number. For example, if I enter "1025" I'd like Excel to return the value "1025". If I enter "987" I'd like Excel to return the value "987".
The entered numbers will be only positive integers in these number ranges. Numbers outside these ranges would be rejected. This would apply to only one cell in one worksheet.
Thanks in advance for any help anyone might be.
Sincerely,
l1011driver
I have a worksheet in which I'd like to format a cell such that the number entered is formatted based on the input value.
If the entered value is between 2500 and 3500 I would like for Excel to return that number with a decimal inserted to two decimal places. For example, if I enter "3015" I'd like Excel to return the value "30.15". If I enter "3000" I'd like Excel to return the value "30.00" (as opposed to "30").
If the entered value is between 700 and 1500 I would like for Excel to return that number. For example, if I enter "1025" I'd like Excel to return the value "1025". If I enter "987" I'd like Excel to return the value "987".
The entered numbers will be only positive integers in these number ranges. Numbers outside these ranges would be rejected. This would apply to only one cell in one worksheet.
Thanks in advance for any help anyone might be.
Sincerely,
l1011driver