|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 14th, 2004, 09:09 PM
|
|||
|
|||
If Then Statements
Need help. Need to turn the following into a formula within Excel.
If B1945 then A19 If B19=45 but 100 then B19*A20 If B19=100 but 300 then B19*A21 Thanks, 
|
|
#2
June 14th, 2004, 09:17 PM
|
|||
|
|||
|
If Then Statements
Hi
try =IF(B19=100,IF(B19300,B19*A21,"not defined"),IF(B19=45,B19*A20,A19)) I assumed that your first condition should read B1945 -- Regards Frank Kabel Frankfurt, Germany mh4568 wrote: Need help. Need to turn the following into a formula within Excel. If B1945 then A19 If B19=45 but 100 then B19*A20 If B19=100 but 300 then B19*A21 Thanks,
|
|
#3
June 14th, 2004, 10:47 PM
|
|||
|
|||
|
If Then Statements
Hi, yes the first condition should be .
Works likes a charm. Thanks very much, Mark "Frank Kabel" wrote: Hi try =IF(B19=100,IF(B19300,B19*A21,"not defined"),IF(B19=45,B19*A20,A19)) I assumed that your first condition should read B1945 -- Regards Frank Kabel Frankfurt, Germany mh4568 wrote: Need help. Need to turn the following into a formula within Excel. If B1945 then A19 If B19=45 but 100 then B19*A20 If B19=100 but 300 then B19*A21 Thanks,
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
