Thursday, August 16, 2012

yogi_What Can Be Used For Excel LOOKUP Function In Google Docs Spreadsheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #702   Aug 16, 2012

user supermiah said: (!category-topic/docs/spreadsheets/QHx17gtr47g%5B1-25%5D)
Substitue for LOOKUP function
I have a spreadsheet in EXCEL that has the following formula:
I use this to subtract certain dollar amounts if K2 is equal to the first parentheses. Since the LOOKUP function does not work how would I do this in google spreadsheet?
I want K2 to subtract 50 for anything 700 or less, and 75 for anything 1000 or less, and so on and so forth.
following is a solution to the problem -- I have also provided a formula that will work both in Google spreadsheet as well as in Excel