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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|