Compare 2 cells then use data in 3rd cell

Danielaes 2 Posts Friday January 5, 2018Registration date January 10, 2018 Last seen - Jan 8, 2018 at 12:46 AM - Latest reply: ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen
- Jan 10, 2018 at 04:44 PM
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
See more 

3 replies

Reply to this topic
ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - Jan 8, 2018 at 05:08 PM
0
Helpful
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!

Respond to ac3mark
Danielaes 2 Posts Friday January 5, 2018Registration date January 10, 2018 Last seen - Jan 10, 2018 at 03:02 AM
0
Helpful
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
Respond to Danielaes
ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - Jan 10, 2018 at 04:44 PM
0
Helpful
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 (,)!
Respond to ac3mark