Compare 2 cells then use data in 3rd cell [Closed]

Report
Posts
2
Registration date
Friday January 5, 2018
Status
Member
Last seen
January 10, 2018
-
 Blocked Profile -
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

3 replies


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!

Posts
2
Registration date
Friday January 5, 2018
Status
Member
Last seen
January 10, 2018

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

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 (,)!