Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
I need the formula to come back with certain money when the cell above has a
certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! -- Thank you so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
Try this in D2 as the start
=IF(D1<2,0,IF(D1=3,5,IF(D1=2,3,"undefined"))) The "undefined" is out there for any value between 2 and 3, such as 2.5. "Cat" wrote: I need the formula to come back with certain money when the cell above has a certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! -- Thank you so much! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
On Thu, 7 Aug 2008 09:55:02 -0700, Cat
wrote: I need the formula to come back with certain money when the cell above has a certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! Assuming that there are only integers in D5 you may try this formula: =IF(D5<2,0,IF(D5=2,3,5)) Hope this helps / Lars-Åke |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
Try:
=IF(D6=2,2,IF(D62,5,0)) Or: =(D61)*2+(D62)*3 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Cat" wrote in message ... I need the formula to come back with certain money when the cell above has a certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! -- Thank you so much! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
IT WORKED! YOU ARE A ROCK STAR!!!
-- Thank you so much! "JLatham" wrote: Try this in D2 as the start =IF(D1<2,0,IF(D1=3,5,IF(D1=2,3,"undefined"))) The "undefined" is out there for any value between 2 and 3, such as 2.5. "Cat" wrote: I need the formula to come back with certain money when the cell above has a certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! -- Thank you so much! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula nesting?
Looks like I wasn't the only one to provide a solution - just the quickest
one on the keyboard ---- this time. "Cat" wrote: IT WORKED! YOU ARE A ROCK STAR!!! -- Thank you so much! "JLatham" wrote: Try this in D2 as the start =IF(D1<2,0,IF(D1=3,5,IF(D1=2,3,"undefined"))) The "undefined" is out there for any value between 2 and 3, such as 2.5. "Cat" wrote: I need the formula to come back with certain money when the cell above has a certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the cell above has a 2 in it it should have $3 come back. If it has a 3 or higher it should have $5 come back. If the cell is lower than 2 it should have $0. Please see example below: C D E F G H ------------------------------------------------------------- John Doe 3 2 1 4 0 <-------------------Condition ------------------------------------------------------------- $5 $3 $0 $5 $0 <-----------------Formula ------------------------------------------------------------ PLEASE HELP! -- Thank you so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting of more than 7 in an IF formula | Excel Worksheet Functions | |||
NESTING FORMULA | Excel Worksheet Functions | |||
Nesting Formula | Excel Discussion (Misc queries) | |||
Formula nesting | Excel Worksheet Functions | |||
nesting another formula | Excel Worksheet Functions |