Conditional equation
Closed
kpoirier
rizvisa1
- Posts
- 1
- Registration date
- Monday January 14, 2013
- Status
- Member
- Last seen
- January 14, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Conditional equation
- Little alchemy equations - Guide
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
1 reply
rizvisa1
Jan 14, 2013 at 05:57 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 14, 2013 at 05:57 PM
Well you can have nested if
(for blank)
=IF(OR(C23=0, C23=""),"", IF((AND(C23<2, C23>0)), 300,(C23-2)*E15+E14) )
or
for zero
=IF(OR(C23=0, C23=""),0, IF((AND(C23<2, C23>0)), 300,(C23-2)*E15+E14) )
(for blank)
=IF(OR(C23=0, C23=""),"", IF((AND(C23<2, C23>0)), 300,(C23-2)*E15+E14) )
or
for zero
=IF(OR(C23=0, C23=""),0, IF((AND(C23<2, C23>0)), 300,(C23-2)*E15+E14) )