Compare 2 cells then use data in 3rd cell Closed

Question

hi there 

hope you can help me with this please

i need to do the following for a stock vs sales management sheet

if 

a1 = b1 then d1*c1 Lock e1
a1 = b7 then d7*c1 Lock e1
a2 = b2 then d2*c2 Lock e2
a2 = B7 then d7*c2 Lock e2


reason for lock once data has been calcululated on that day it must remain like that and not fluctutate as per cost of materials hope i explained it ok i tried lol

Thanks in advance

ac3mark · Answer

The syntax for is is as folow:
=IF(logic_test,true,false)

So, using the above syntax, we get:
=IF(a1>B1,C1,"NOT GREATER")


The above code would see if A1 is greater than B1.  If it is, then display the value from C1, if not then display the value of "NOT GREATER".


Have fun!

Danielaes · Answer

Hi Thanks bud

But that doesn't look like what i need i did the following if formula but it gives me a error once i start adding more than 2 arguments 

=IF(J5="8mm";"L5*'Packing stock'!D3;IF(J5='10 mm";L5*'Packing stock'!D4)
=IF(J6="8mm";"L5*'Packing stock'!D3;IF(J5='10 mm";L6*'Packing stock'!D5)
=IF(J7="8mm";"L5*'Packing stock'!D3;IF(J5='10 mm";L7*'Packing stock'!D6)

my problem starts here my arguments goes on to 12 mm,12,7 mm,16 mm,19 mm,20 mm,22,2 mm,25 mm.
after the 10mm argument was added if i add any more arguments then it gives me error messages 

i also want to add AND statement to each argument but will do that once i get past this point

Thanks in Advance

ac3mark · Answer

If you wish to use AND, then start with and as in:

=AND(if(a1>b1),if(B1>c1)

The above would return true if A1 was greater than B1, and B1 was greater than C1.

I hope this example helps. 

In your other if statements, you are using semi colons, which are wrong.  You need to use a comma (,)!

Compare 2 cells then use data in 3rd cell

3 responses

Similar discussions

Subscribe To Our Newsletter!