hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
column B & column C are variables
column E & column F are constants (2.5 & -2.5 respectively)
Output column is column H.
Please bear with my language...please
I am using H2<f2,-100,0)) and="" able="" to="" get="" correct="" answer.
=IF(B2>E2,100,IF(C2 is less than F2,-100,0))
<f2,-100,0))
<f2,-100,0))
But H4=Incorrect. Answer should be -100 since C4=-2.6 which is less than F4 i.e. as long as C is non zero the formula should consider 2nd IF.
What should be the 'correct' formula.
Sheet1
<tbody>
</tbody>
<tbody>
</tbody>
Many thanks for .....with me.</f2,-100,0))
</f2,-100,0))
</f2,-100,0))>
column E & column F are constants (2.5 & -2.5 respectively)
Output column is column H.
Please bear with my language...please
I am using H2<f2,-100,0)) and="" able="" to="" get="" correct="" answer.
=IF(B2>E2,100,IF(C2 is less than F2,-100,0))
<f2,-100,0))
<f2,-100,0))
But H4=Incorrect. Answer should be -100 since C4=-2.6 which is less than F4 i.e. as long as C is non zero the formula should consider 2nd IF.
What should be the 'correct' formula.
Sheet1
B | C | D | E | F | G | H | |
2 | 3.2 | 0 | 2.5 | -2.5 | 100 | ||
3 | 3.2 | -2.4 | 2.5 | -2.5 | 100 | ||
4 | 3.2 | -2.6 | 2.5 | -2.5 | 100 | ||
5 | 0 | -4.77 | 2.5 | -2.5 | -100 |
<tbody>
</tbody>
Spreadsheet Formulas | ||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Many thanks for .....with me.</f2,-100,0))
</f2,-100,0))
</f2,-100,0))>
Last edited: