Conditional equation [Closed]

Question

Previous Topic Next Topic

Conditional equation [Closed]

Report

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: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Jan 14, 2013 at 05:57 PM

Hello,

I am desperately trying to write a formula for the following:

If C23 is less than 2 but greater than zero, then value of E14, and if not, then (C23-2)*E15+E14.

I pretty much have it, but if I make C23 zero or leave it blank its shows 150. If C23 is blank or zero then the cell should be blank or zero.

This is what I have now: =IF((AND(C23<2, C23>0)), 300,(C23-2)*E15+E14)

Any suggestions would be greatly appreciated. Thank you!

Conditional equation
Available memory less than 15mb condition zero - How-To - Counter Strike
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

Ask a question

rizvisa1 · Answer 1 · 2013-01-14T17:57:37-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
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) )

Conditional equation [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!