Lookup function
Hi all,
This is driving me crazy. I am trying to make up this formula
=IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2 from
20.72 and total)
Then if E2 = 2 and G2 is 41.44 or less its "ok". If over 20.72 subtract G2
from 41.44 and total)
I have 15 numbers to do this way .
Any help will really be appreciated.
I am new to this an am not sure what I need to show you
|