Forum Discussion
Don_OliverChelsea38
Mar 17, 2023Copper Contributor
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