| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make a more complicated version of the if function
Hi, I would like to make a formula that allows me to have a number set automatically according to the number i put in the previous cell. Hope you understand what i mean I want to put a number in cell A1 so that there appears another number automatically in cell A2, this number will depend on the number i put in A1. Let's say i do this: I put the number 0 in CELL A1 ----- CELL A2 automatically becomes 0.4 CELL A1 = 0 to / or equal to 1.25 ----- CELL A2 = 0.4 CELL A1 = 1.25 to / or equal to 3.10 ----- CELL A2 = 0.4 etcetera.... Sorry for my bad English i'm from Belgium. Hope you can help me out. -- darblooz ------------------------------------------------------------------------ darblooz's Profile: http://www.excelforum.com/member.php...o&userid=34939 View this thread: http://www.excelforum.com/showthread...hreadid=546725 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a more complicated version of the if function
According to your post, A2 always contains 0.4, so just enter 0.4
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "darblooz" wrote in message ... Hi, I would like to make a formula that allows me to have a number set automatically according to the number i put in the previous cell. Hope you understand what i mean I want to put a number in cell A1 so that there appears another number automatically in cell A2, this number will depend on the number i put in A1. Let's say i do this: I put the number 0 in CELL A1 ----- CELL A2 automatically becomes 0.4 CELL A1 = 0 to / or equal to 1.25 ----- CELL A2 = 0.4 CELL A1 = 1.25 to / or equal to 3.10 ----- CELL A2 = 0.4 etcetera.... Sorry for my bad English i'm from Belgium. Hope you can help me out. -- darblooz ------------------------------------------------------------------------ darblooz's Profile: http://www.excelforum.com/member.php...o&userid=34939 View this thread: http://www.excelforum.com/showthread...hreadid=546725 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a more complicated version of the if function
Sorry, my mistake i edited my post. -- darblooz ------------------------------------------------------------------------ darblooz's Profile: http://www.excelforum.com/member.php...o&userid=34939 View this thread: http://www.excelforum.com/showthread...hreadid=546725 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a more complicated version of the if function
Would you care to post that edit. I don't see it here, as I am in the public
newsgroups, not your forum. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "darblooz" wrote in message ... Sorry, my mistake i edited my post. -- darblooz ------------------------------------------------------------------------ darblooz's Profile: http://www.excelforum.com/member.php...o&userid=34939 View this thread: http://www.excelforum.com/showthread...hreadid=546725 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a more complicated version of the if function
Off course, sorry. Here's the part i edited. Let's say i do this: I put the number 0 in CELL A1 ----- CELL A2 automatically becomes 0.4 CELL A1 = 0 to / or equal to 1.25 ----- CELL A2 = 1 CELL A1 = 1.25 to / or equal to 3.10 ----- CELL A2 = 2 etcetera.... -- darblooz ------------------------------------------------------------------------ darblooz's Profile: http://www.excelforum.com/member.php...o&userid=34939 View this thread: http://www.excelforum.com/showthread...hreadid=546725 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a more complicated version of the if function
darblooz wrote: Off course, sorry. Here's the part i edited. Let's say i do this: I put the number 0 in CELL A1 ----- CELL A2 automatically becomes 0.4 CELL A1 = 0 to / or equal to 1.25 ----- CELL A2 = 1 CELL A1 = 1.25 to / or equal to 3.10 ----- CELL A2 = 2 etcetera.... -- darblooz "etcetera" implies that you have more of these values, so it might be better to set up a small table which lists the values and what you want them to be tranformed into, and then you can use a VLOOKUP formula with the final parameter set to TRUE. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| How do I make a compound function? | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Improve Excel Help Text - Make easier to Find Function Refs | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Hybrid Mode
