Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |