Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- 461K Members
- 6,543 Online
- 559K Conversations

- Home
- :
- Excel
- :
- General Discussion
- :
- Help with Excel formula

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Conversation Options

- Subscribe to RSS Feed
- Mark Conversation as New
- Mark Conversation as Read
- Pin this Conversation for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-17-2019 02:10 PM

Hi, I am pulling my hair out trying to write an Excel formula for the following action - can you help. Essentially, depending on the value entered into A1, the value in A2 should be multiplied by 4, 6, 8, or 10. Here's the description of what I need:

If A1 = 1, then MULTIPLY A2 by 4 and MULTIPLY the result by A3

BUT

If A1 = 2, then MULTIPLY A2 by 6 and MULTIPLY the result by A3

BUT

If A1 = 3, then MULTIPLY A2 by 8 and MULTIPLY the result by A3

BUT

If A1 = 4, then MULTIPLY A2 by 10 and MULTIPLY the result by A3

Thanks for any help you can give!

Labels:

12 Replies

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-17-2019 05:04 PM

I guess, it should be...

`= 2*(A1+1)*A2*A3`

And what if A1=0?

If you don't want to calculate when A2=0 or blank, then it should be...

`=IF(A1=0,"", 2*(A1+1)*A2*A3)`

And what if A1>4, would you like to calculate by following the pattern or you would not like to calculate then?

If you don't want to calculate if either A1=0 or A1>4 then...

`=IF(OR(A1=0,A1>4),"", 2*(A1+1)*A2*A3)`

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-17-2019 10:10 PM - edited 09-17-2019 10:15 PM

@Subodh_Tiwari_sktneer Thanks, but I don't think that quite covers what I need. Users are limited to the number they can enter into A1 - it's either 1, 2, 3 or 4. The difficulty I'm having is in writing a formula that says:

If 1 is entered into A1, do (A2 * 4) *3

If 2 is entered into A1, do (A2 * 6) *3

If 3 is entered into A1, do (A2 *

If 4 is entered into A1, do (A2 * 10) *3

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-17-2019 10:14 PM

@Sergei Baklan Thanks, but I don't think this formula will do what I need. Users can only enter 1, 2, 3 or 4 into A1, so the formula I'm trying to create needs to say:

If 1 is entered into A1, do (A2 * 4) *3

If 2 is entered into A1, do (A2 * 6) *3

If 3 is entered into A1, do (A2 *

If 4 is entered into A1, do (A2 * 10) *3

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Best Response confirmed by
LeDanJohnson (Occasional Contributor)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 12:54 AM

First variant of requirements is

```
If A1 = 1, then MULTIPLY A2 by 4 and MULTIPLY the result by A3
BUT
If A1 = 2, then MULTIPLY A2 by 6 and MULTIPLY the result by A3
BUT
If A1 = 3, then MULTIPLY A2 by 8 and MULTIPLY the result by A3
BUT
If A1 = 4, then MULTIPLY A2 by 10 and MULTIPLY the result by A3
```

Latest one

```
If 1 is entered into A1, do (A2 * 4) *3
If 2 is entered into A1, do (A2 * 6) *3
If 3 is entered into A1, do (A2 * *3
If 4 is entered into A1, do (A2 * 10) *3
```

Which one is correct?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 01:03 AM

@Sergei Baklan In the second version, I should have written *A3 (not *3). With that amend, the two requirements are the same - I tried to simplify them in the second version. Thanks,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 01:15 AM

When the formula as before shall work

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 03:01 AM

@Sergei Baklan I see how it works now. Thanks for taking the time to solve this for me.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 03:01 AM

@Subodh_Tiwari_sktneer Thanks for all your help - this works.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

09-18-2019 03:22 AM

You're welcome! Glad we could help.

Now you may mark your question as Solved by choosing one of the posts which resolved your question as Best Answer/Response.

You may also click on Like buttons under the posts which you found helpful, that's another way to say thanks.

Related Conversations

Stable version of Edge insider browser

HotCakeX
in
Discussions
on
10-12-2019
35.1K
Views

7 Likes

35 Replies

flashing a white screen while open new tab

Deleted
in
Discussions
on
10-05-2019
31K
Views

14 Likes

14 Replies

How to Prevent Teams from Auto-Launch

chenrylee
in
Microsoft Teams
on
06-27-2019
179K
Views

8 Likes

29 Replies

Security Community Webinars

Valon_Kolica
in
Security, Privacy & Compliance
on
10-22-2019
16.3K
Views

12 Likes

13 Replies

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © Microsoft