Previous Topic Next Topic

New If problem

Closed
Fatdog - 3 Nov 2009 à 20:33
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Nov 2009 à 21:51
Hello,

Im having some real problems trying to get an if formula to work. Well i think its an if formula i need.

I want a sum to take place based on one word or another sum to take place based on another word all from the same cell.

my formula i have at present could be way off but please advise if anyone can

=if(B11=Long,=[Sum(P11-G11)*Q11],=[sum(G11-P11)*Q11])

so if the word is short i want the outcome to be the sum of (G11-P11)*Q11 but if the word is long i want the outcome to be the sum of (P11-G11)*Q11.

any assistnce wold be great

regards

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
3 Nov 2009 à 21:51
what is meant by
Sum(P11-G11)*Q11
it is simply (P11-G11)*Q11

I presume there are only two choices for B11 Long or short in that case
use this formula

=if(B11="LONG",(G11-P11)*Q11,(P11-G11)*A11)

this means if B11 is "Long" then it is (G11-P11)*Q11
otherwise (P11-G11)*Q11

where are going to park this formula NOT in B11 otherwise it will give circular refrence error.