Conditional Formula Problem...

[Guest]

Here's our problem... we have some things listed in LBS and others in BGS for
their unit of measure... so when reviewing inventory - we're constantly
having to double check things & have run into many issues/errors because of
this setting...
I would like to figure out how to enter a formula that would say

If UOM = BG - then do nothing ... but, IF UOM = LB, then (available/50)...

Available UOM
1,050.00 LB
415 BG

Can anyone help???

 

[Guest]

If your data is columns A &B ,then in column C:

=IF(B2="LB",A2/50,A2)

and copy down.