| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
If a1 has a value less than 11908.00 a2 should return 25.00
If al has a value more than 230954.00 a2 should return 485.00 if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00 Can someone please help me with this. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement
=IF(A1<11908,25,IF(A1<=230954,0,485))
-- Best Regards, Luke M "Tina" wrote in message ... If a1 has a value less than 11908.00 a2 should return 25.00 If al has a value more than 230954.00 a2 should return 485.00 if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00 Can someone please help me with this. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement
hI Tina
=IF(A1<11908,25,IF(A1230954,485,0)) "Tina" wrote: If a1 has a value less than 11908.00 a2 should return 25.00 If al has a value more than 230954.00 a2 should return 485.00 if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00 Can someone please help me with this. Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement
Check out another approach:
=25*(A1<11908)+485*(A1230954) Micky "Tina" wrote: If a1 has a value less than 11908.00 a2 should return 25.00 If al has a value more than 230954.00 a2 should return 485.00 if a1 has a value between 11908.00 and 230954.00 a2 should return 0.00 Can someone please help me with this. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
