awagdarikar
Board Regular
- Joined
- Jun 20, 2008
- Messages
- 115
Greetings,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
This is Aniruddha and I am a new member of this site. I need to find the smallest positive value from a range A1:D1 (containing both positive and negative values) as illustrated below.<o></o>
<o> </o>
Cell A1: 176.12 Cell B1: -26.12 Cell C1:3.88 Cell D1: 363.88<o></o>
<o> </o>
Obvious answer is Cell C1: 3.88 I have tried hard but I am not able to set a formula for this issue.<o></o>
<o> </o>
Thank you,<o></o>
<o> </o>
Aniruddha<o></o>
<o> </o>
This is Aniruddha and I am a new member of this site. I need to find the smallest positive value from a range A1:D1 (containing both positive and negative values) as illustrated below.<o></o>
<o> </o>
Cell A1: 176.12 Cell B1: -26.12 Cell C1:3.88 Cell D1: 363.88<o></o>
<o> </o>
Obvious answer is Cell C1: 3.88 I have tried hard but I am not able to set a formula for this issue.<o></o>
<o> </o>
Thank you,<o></o>
<o> </o>
Aniruddha<o></o>