Conditional equation
Closed
kpoirier
Posts
1
Registration date
Monday January 14, 2013
Status
Member
Last seen
January 14, 2013
-
Jan 14, 2013 at 05:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 14, 2013 at 05:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 14, 2013 at 05:57 PM
Related:
- Conditional equation
- Equation editor free download - Download - Word processors
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
- Conditional hyperlink excel ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 14, 2013 at 05:57 PM
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) )