| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple (I bet) Newbie question...
I hope this is possible to have happen all in 1 formula
How can i compose a formula that would acheive the following: If the number in J5 is at least 10,000 but up to 24,999 then multiply cell I5 X B5 If the number in J5 is at least 25,000 but up to 49,999 then multiply cell I5 X C5 If the number in J5 is at least 50,000 but up to 99,999 then multiply cell I5 X D5 If the number in J5 is over 100,000 or above then multiply cell I5 X E5 If the number in J5 is UNDER 10,000 then display "Under Min" (or something like it) Thanks for reading!! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Simple (I bet) Newbie question...
Hi
The formula should be entered as one line! =IF(J5<10000,"Under Min",IF(J5<25000,I5*B5,IF(J5<50000,I5*C5,IF(J5<100 000,I5*D5,I5*E5)))) Best regards, Per "Edward" skrev i meddelelsen ... I hope this is possible to have happen all in 1 formula How can i compose a formula that would acheive the following: If the number in J5 is at least 10,000 but up to 24,999 then multiply cell I5 X B5 If the number in J5 is at least 25,000 but up to 49,999 then multiply cell I5 X C5 If the number in J5 is at least 50,000 but up to 99,999 then multiply cell I5 X D5 If the number in J5 is over 100,000 or above then multiply cell I5 X E5 If the number in J5 is UNDER 10,000 then display "Under Min" (or something like it) Thanks for reading!! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Simple (I bet) Newbie question...
Thank You So Much!!!!
"Per Jessen" wrote in message ... Hi The formula should be entered as one line! =IF(J5<10000,"Under Min",IF(J5<25000,I5*B5,IF(J5<50000,I5*C5,IF(J5<100 000,I5*D5,I5*E5)))) Best regards, Per "Edward" skrev i meddelelsen ... I hope this is possible to have happen all in 1 formula How can i compose a formula that would acheive the following: If the number in J5 is at least 10,000 but up to 24,999 then multiply cell I5 X B5 If the number in J5 is at least 25,000 but up to 49,999 then multiply cell I5 X C5 If the number in J5 is at least 50,000 but up to 99,999 then multiply cell I5 X D5 If the number in J5 is over 100,000 or above then multiply cell I5 X E5 If the number in J5 is UNDER 10,000 then display "Under Min" (or something like it) Thanks for reading!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Real Newbie newbie question | New Users to Excel | |||
| Simple excel question for newbie | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Simple formula for newbie! | New Users to Excel | |||
![Edward[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
