You are here: HomeExcelTutorials

'Return a value based on the value of another cell'

'Return a value based on the value of another cell'

Price: FREE

for looking,
I need a formula to do the following - I don't think its that difficult I just don't know the full formula.
If the value in cell C is less than £99.99 bring back £40 OR of the value in cell C is between £100 & £9,99.99 bring back £70 OR if the value in cell C is £10,00 or above bring back £100.

Visit publisher's web-site: 'Return a value based on the value of another cell'

Category and Tags: ExcelTutorials :

Related Tutorials

Need to return value of cell based on parameter.

Free: Yes
Tags: Excel ›

Need help urgently,
I'm trying to return the value of a cell based on another cell's value.
I.E. F7 = 200.
F8 = Sheet1!(Q214)
Essen tally, I want to return from another sheet column(Q), same sheet Row(F7 + 14)
Is this possible? This is what I tire but its not working.
=CELL("contents",(Sheet1!Q(VALUE(F7))

Return column based on cell value.

Free: Yes
Tags: Excel ›

I wish to show a cell address whose column is determined by the value of a different cell. For instance if cell A1 has the text "d" then cell A2 would return the value of cell D2 And if the cell had the text "f" then cell A2 would return the value of F2.
Also the linked cell would be on a different worksheet, does this make a difference?

lookup and return a value based on a range

Free: Yes
Tags: Excel ›

I want to place a formula in cell K2 that looks up the value calculated in cell J2 and compares it to the range of data in cells B9:C20. It then returns a result from cells A9:A20 based on the range. In this example, 24.9 should return a value of 1.5. The example in the second line, 49.9 should return a value of 3.0 in cell K3.
I have tried lookup, but it fails when I use a range.
Using excel 2010

Return Results of a cell based on cell referenced in a cell

Free: Yes
Tags: Excel ›

I am trying to write a formula that will return the results of a cell based on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this?

Ranking based on values

Free: Yes
Tags: Excel ›

I'm trying to rank a set of individuals based on scores. Specifically, I'm want to find the top three each day. In the attached example, cell B2 would return "D*ck" since he had the highest score that day (cell A2). Cell C2 would return "Sally" since she had the second highest score and cell D2 would return "Jennifer" since she had the third highest score. My goal is to do this for everyday in the time series.
Can anyone help me out with a function that can accomplish this?

Related Applications & Scripts

PHP Map + Location Plugin

Free: No
Tags: PHP › Excel Geolocation

This is a collection of location based functions that can get a users location based on their ip address using the IPInfoDB api, return advanced details on a specific location with the Yahoo PlaceFinder api, or dynamically create maps (as images or with javascript) using the Google Maps api.
This function interacts with the IPInfoDB.com API to get a users location based on their IP address. It can return city, state, country, latitude & longitude and is accurate within a 25 mile radius. This function accepts an IP Address and returns an array of location based values.

Bookmark Popup

Free: No

Do you want your visitors to return to your site and share your message with friends, family, and coworkers? The easiest way to keep visitors coming back is to encourage them to bookmark your site. By bookmarking a website visitors are reminding themselves that they want to return to your site.
Not only will this increase your sites basic but it also increases your sites popularity. Many web site owners do not realize that a sites true popularity is based upon its repeat visitors. The number of repeat visitors shows that your site is so appealing that it not only attracts many unique visitors, but it also encourages these visitors to return time and time again. If you are someone that is selling a product the majority of sales and conversions are made because of return visitors. It often takes many visitors more than one visit to a web site to decide whether or not they are going to make a purchase. I myself will often visit an online store several times before committing myself to an actual purchase.

My ASP Paypal E-Goods Protector

Free: No
Tags: ASP › Excel E-Commerce PayPal

Using Paypal's IPN technology this software will prevent people from stealing your software. After each successful payment, the download url is sent automatically by email to the customer. This will avoid the vulnerable "return url" variable. It is written in ASP/VBscript using Macromedia Ultradev and is 100% customizable and extendible.
Features:
Protects e-goods from being stolen
Protects against price tampering
Unlimited number of products
Automatically sends file url to customers
Completely web-based
100% customizable
Uses PayPal's IPN technology
Works with 'Single Item Purchases' and now PayPal Cart!
Will only allow 'completed' & 'verified' sales
Generates paypal buttons/forms
Online html editor to create you own emails!
Supports multi-currency

Flash Chat

Free: No

This stylish, flash based utility will insert a colorful chat box for your visitors to use. This allows user to user interaction and constant user-admin feedback. There's no loading time and no programming skills are required, it's functionally similar to any instant message program out there, very user friendly, appealing to the eye and fast.
FEATURES
- This Dreamweaver extension can be very easily inserted in any webpage.
- It works in both Windows and Macs.
- Allows to maintain a conversation flow between several users of your website.
- It is based on Flash, which makes FlashChat a multi-platform tool. It is supported by all modern browsers.
- It is entirely file-based.You don't need to handle databases.

Zoki Poll: high-tech poll system

Free: Yes
Tags: PHP › Excel Ajax Polls and Voting

This package is light and high-tech poll system, based on AJAX and XML. It can be simply integrated in almost every site. It is written in HTML, CSS and JavaScript with small backend files in PHP.
Features:
Do not require DataBase (optional).
Based on AJAX (asynchronous requests for data).