Multiple IF querie

[RichardWatson]

Hi,

I am having great problems trying to use IF with multiple results.

For example:
A1 and B1 have a number
C1 has a WORD (up or down) which is derived form an equasion made with A1 and B1.

I want D1 to have the calculation that IF C1 says "Up" then I want to Minus B1 from A1 but IF C1 says "down" I want to minus B1 from A1.

I have scoured many forums and tutorials and cannot find an answer but this place seems to have the best experts!

Many Thanks
Rich

 

[VoG]

I want D1 to have the calculation that IF C1 says "Up" then I want to Minus B1 from A1 but IF C1 says "down" I want to minus B1 from A1.

That reads as the same to me. Perhaps you mean

=IF(C1="Up",A1-B1,IF(C1="down",B1-A1,""))

 

[RichardMGreen]

In D1 you would need:-
=if(c1="Up",a1-b1,b1-a1)

::edit::

Just beaten to it.

 

[RichardWatson]

That reads as the same to me. Perhaps you mean

=IF(C1="Up",A1-B1,IF(C1="down",B1-A1,""))

thanks that is exactly what I have been trying but I keep getting the pop up window that there is an error in the formula.

 

[RichardWatson]

In D1 you would need:-
=if(c1="Up",a1-b1,b1-a1)

::edit::

Just beaten to it.

again thanks but also getting the error in the formula.

Could this be because C1 also has a formula to get the result "up" or "down"?

 

[VoG]

The formula works for me

Excel Workbook
	A	B	C	D	E
1	10	8	Up		2
Sheet7

 

[RichardWatson]

The formula works for me

Excel Workbook
	A	B	C	D	E
1	10	8	Up		2
Sheet7

got it and it has worked though in your example you have used a , and I have had to use ;

Thanks so much!!