![]() |
#1
|
|||
|
|||
![]()
I am putting together a spreadsheet and I need to set up a rule or formula that will:
If cell (A1) equals 'FF' then cell (A2)'s value subtracts 100 in cell (A3), but if cell (A1) equals 'SD' then cell (A2)'s value adds 50 in cell (A3), but if cell (A1) equals 'REV' then cell (A2)'s value just stays the same in cell (A3). I'm using rule in A3 =IF(A1="FF",A2-100,IF(A1="SD",A2+50,IF(A1="REV",A2,""))) How can I add to this rule, so then if cell (B1) equals 'MS', then the entire rule is over-rided and 1908 is added to the value in (A2) in cell (A3). |
#2
|
||||
|
||||
![]()
Cross posted without links at http://www.excelguru.ca/forums/showt...xt-within-cell
Read http://www.excelguru.ca/content.php?184 to understand why links to cross posts are required then add links to all your other cross posts.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Side view: Color of summary with formular interrupted | Mojo99 | Project | 5 | 10-07-2016 09:11 AM |
Cell Ref does not automatically change when formula is copied because of data orientation | Kristinmc | Excel | 4 | 08-01-2016 10:57 AM |
![]() |
dlearyfun | Excel | 1 | 10-26-2014 09:44 AM |
xl table formula change on add row | mikec | Excel Programming | 6 | 11-10-2013 04:54 PM |
![]() |
msheyworth | Excel | 2 | 03-23-2013 11:43 AM |