chanson329
New Member
- Joined
- Jul 29, 2013
- Messages
- 5
I need one cell to be subject to the followingconditional statements and just can't get the formula correct. Basically I need the cell to calculate three different conditions
=if(l8<10,0,l8)<o></o>
=if(l8>=10,and(c8>15),l8,0)<o></o>
=if(l8>=20,and(c8<15),l8,0)<o></o>
=if(l8<10,0,l8)<o></o>
=if(l8>=10,and(c8>15),l8,0)<o></o>
=if(l8>=20,and(c8<15),l8,0)<o></o>