Forum Discussion

Don_OliverChelsea38's avatar
Don_OliverChelsea38
Copper Contributor
Mar 17, 2023
Solved

Need Help with a formula

Hello.

 

I'm a real Excel (on a Mac) novice, although I can do some basic things.

Here's the problem:

How do I write a formula that will do the following:

 

I need help to create a new formula, replacing the existing formula "=K60*N60" in cell P60

 

EXAMPLE:

IF user types "Y" in cell L60, then I would like the price already entered in cell N60 to be doubled and the result show in cell P60.

If user does not type "Y" in L60, then what would show in P60 should be =K60*N60 (the standard value for that cell).

 

I looked for examples in the help sections but couldn't figure out how to do this successfully.

Any assistance will be greatly appreciated.

Thank you in advance.

 

Don Oliver

Resources