# Compare 2 cells then use data in 3rd cell

Closed
Danielaes Posts 2 Registration date Friday January 5, 2018 Status Member Last seen January 10, 2018 - Updated on Jan 8, 2018 at 06:30 AM
Blocked Profile - 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

Related:

## 3 responses

Blocked Profile
Jan 8, 2018 at 05:08 PM
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 Posts 2 Registration date Friday January 5, 2018 Status Member Last seen January 10, 2018
Jan 10, 2018 at 03:02 AM
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