Your Universal Remote Control Center
RemoteCentral.com
Custom Installers' Lounge Forum - View Post
Previous section Next section Up level
Up level
The following page was printed from RemoteCentral.com:

Login:
Pass:
 
 

Topic:
Sorta OT - Excel / Google Sheets question
This thread has 2 replies. Displaying all posts.
Post 1 made on Monday February 22, 2016 at 11:50
sofa_king_CI
Super Member
Joined:
Posts:
June 2009
4,230
Is there a way to create an evaluative formula that sort of uses and If/Then.

I want to have a cell apply a number (ultimately its a multiplier) based on the value of another cell.

I have 5 cells that will have data inputed manually. A column cell at the end of those cells does the avg of the 5. The next cell is for assigning a multiplier based on what the avg number is.

For simplified example
If cell number is less than 10,000, put in a number 1
If cell number is 10,001-20,000, the number should be 1.3
iF cell number is 70,000-79,000, the number would be 3.5

The numbers don't matter so much as how to fill in the multiplier automatically based on what the avg came out to be.
do wino hue?
Post 2 made on Monday February 22, 2016 at 12:08
buzz
Super Member
Joined:
Posts:
May 2003
4,366
You can use the general form:

=if(condition, true, false)

example:

=if(a1=b1, "Equal", "Not Equal")

The 'true' and 'false' can be statements:

=if(condition_1, true_1, if(condition_2, true_2, false_2))

Your case is similar to:

=IF(A1>B1,"GT",IF(A1=B1,"Equal","LT"))

---

A little heartburn is the order of calculation, generally left to right, top to bottom. This means that if one cell is calculated and this result is used in another calculation, the first calculation should be left of or above the second calculation.

Last edited by buzz on February 22, 2016 12:17.
Post 3 made on Monday February 22, 2016 at 12:12
BisyB
Advanced Member
Joined:
Posts:
May 2006
964
=IF(AND(A7>=0,A7<=10000),1,IF(AND(A7>=10001,A7<=20000),1.3,IF(AND(A7>=70000,A7<=79000),3.5)))

Obviously using A7 in this example as the cell calculating the total. Now this formula uses the ranges you provided above since I figured that would be easiest to figure out the structure. If the numbers fall in the 20,001-69,999 or 79,001 and above it would return as FALSE.

Last edited by BisyB on February 22, 2016 12:53.
Web Design | Hosting - www.bz303.com


Jump to


Protected Feature Before you can reply to a message...
You must first register for a Remote Central user account - it's fast and free! Or, if you already have an account, please login now.

Please read the following: Unsolicited commercial advertisements are absolutely not permitted on this forum. Other private buy & sell messages should be posted to our Marketplace. For information on how to advertise your service or product click here. Remote Central reserves the right to remove or modify any post that is deemed inappropriate.

Hosting Services by ipHouse