# Need Help with Creating EXCEL Formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Sabiston

Windows XP, Officer 2003, EXCEL

Need formula to perform specific varying functions that will multiply a named CEL by a specific number that will vary by letters entered into a CEL.

Example: CELL Entry is Letter "P". Want another cell to perform and display result of A1*.6

CELL Entry is Letter "B". Want same cell above to perform and display result of A1*.4

CELL Entry is "B/P". Want same cell above to perform and display result of A1*.5

I can do the IF thing and get the formula to work for two arguments, but need to get results for the THREE arguments indicated above.

#### cwwozniak

Chuck
Moderator
Hi and welcome to TSG.

Your use of "CEL" is a bit confusing (at least to me). Are you assigning a name of "CEL" to some specific cell or are you calling any cell a "CEL"?

#### valis

Moderator
think he/she is stating 'cell a1', etc.........

#### Sabiston

CEL meaning Cells in EXCEL Spreadsheet. Need formula to address THREE arguments and invoke THREE responses based on ONE of THREE being TRUE.

#### edhicks

Sabiston
For requested results with answer in c2 try

c2=if(cel="P",a1*.6,if(cel="B",a1*.4,if(cel="B/P",a1*.5,"?????")))
replace ????? with result if cel is none of P,B or B/P

#### Sabiston

Formula works! Thanks so much! It also helped me see what I had been doing wrong. So, problem fix and I learned something. Thanks Again! What a GREAT website!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!