| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Posible IF formula
A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can I write a formula for this. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Posible IF formula
I think this is the formula in B2
=IF(A2=1000,140,IF(A2=2000,14,117)) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Hanah" wrote: A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is 140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can I write a formula for this. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Posible IF formula
Thanks! This works! Great help!
"M Kan" a scris: I think this is the formula in B2 =IF(A2=1000,140,IF(A2=2000,14,117)) -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Hanah" wrote: A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is 140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can I write a formula for this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it posible to have a formula for factorial via vba code? | Excel Worksheet Functions | |||
| is it posible to apply multiple and or functions in a singl cell? | Excel Worksheet Functions | |||
| Auto Maximize posible? | Excel Discussion (Misc queries) | |||
| is it posible to do payslips for a small business in excel | Excel Worksheet Functions | |||
| data validation list - Lengthen ? Posible ? | Excel Worksheet Functions | |||
Linear Mode
