#### delta_negative

##### New Member

- Joined
- Mar 11, 2013

- Messages
- 37

The first desired result is to evaluate cells formatted as numbers to determine if the value > **1.** and <=**6.** so that if the value is 123.40 the value of 120 will be returned. The desired result for the second part of the logical test would be to check if the value is >6 and <=1 and if so return the rounded value to the next higher increment, for instance 126.01 would return 130.Using the following formula, have checked everything but for some reason the AND portion returns false regardless of E13 cell value.
Haven't yet started on the second part, don't know if it is possible in excel?Any help or suggestions greatly appreciated. Using excel 2007.

Code:

` =IF(AND(MID(E13,3,1)<=6,MID(E13,3,1)>1),E13-MID(E13,3,4),"")`

Last edited: