Thread: Lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mary Mary is offline
external usenet poster
 
Posts: 190
Default 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