Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

If statement, that adds a formula.

Posted on 2014-01-03
Medium Priority
407 Views
I have a need to add a formula to a cell if the value of other equals a specific value, and based on that value the formula will change.
Starting at AQ2, if it equals “Bruce”, add the formula “=BQ2” in column M, if AQ2 equals “Rich”, put formula “=BQ2-O2 in column M  (the letter O)

I can handle the copying of the formulas down but need a hand doing the double if statements that add a formula in column M.  Please advise and thanks. -R-
0
Question by:RWayneH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 6

Expert Comment

ID: 39753762
Can the value of AQ2 be anything other than Bruce of Rich?  If those are the only two values than you only need a single if statements.  If there are other values, what do you want to do when it is not Bruce or Rich.
0

LVL 27

Accepted Solution

Steve earned 2000 total points
ID: 39753763
Try this:
`````` =if(aq2=Bruce",BQ2,if(aq2="Rich",BQ2-O2,"FAIL"))
``````
Note, "FAIL' should be replaced with whatever you want in the Cell if AQ2 doesn't match Bruce or Rich.
0

Author Closing Comment

ID: 39756012
Worked!!  Thanks. -R-
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month6 days, 19 hours left to enroll