Thread: IF (AND OR) Statement

I need help to figure out how to add increments into an IF statement if thats possible?

Heres the Data..


Demand =750,000 ( if ) SalesPrice = $2.20

but if SalesPrice increases by $.01
Then Demand decreases by 15,000
if SalesPrice decreases by $.01
Then Demand Increases by 15000

How would I formulate in a way that would change the demand amount when the user changed the SalesPrice Amount???

I've been trying to figure this out for like two days now and I'm lost.

Hello and welcome to the forum,

If I am not mistaken this will require vba or solver. I don't much experience with the latter, but if you are interested in a vba solution, I could give it a try.

abousetta

I apologize, I think I misread your question. There may be a formula for this. Let me get back to you.

abousetta

Hi,

Sorry about that...

Now if A2 is Demand, B2 is SalesPrice(current), C2 is SalesPrice(change) then you can use the following formula in any other cell:

=IF(C2>0,A2+((C2*15000)*100),IF(C2<0,A2+((C2*15000)*100),A2))

abousetta

Thanks for the help, I'm going to give it a try now ;-)

Originally Posted by abousetta

Hi,

Sorry about that...

Now if A2 is Demand, B2 is SalesPrice(current), C2 is SalesPrice(change) then you can use the following formula in any other cell:

=IF(C2>0,A2+((C2*15000)*100),IF(C2<0,A2+((C2*15000)*100),A2))

abousetta

it worked! Thank you so much, I've been pulling my hair out trying to get this one right, I was getting it close but the incrementing wasnt right, still kinda new to this stuff...the only thing I had to do was change the + sign in the second if statement to a - and woo lah ;-)

Thanks again

Glad I could be of assistance. The negative/ positive sign was tricky only because in my excel sheet (C2) I used negative (-0.01) and postive (0.01) numbers. Negative minus negative is positive and that's why I used two different signs in the formula.

If you are satisfied with the results, please mark the thread as [SOLVED] (next to the title on the first post). Also positive recognition (scales) are always welcomed .

Good luck.

abousetta