#1
|
|||
|
|||
I need to change a formular to overide formula
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). |
|
Similar Threads | ||||
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 |
Bulk formula change | 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 |
Quick eplanation of formular | msheyworth | Excel | 2 | 03-23-2013 11:43 AM |