Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2016, 11:21 PM
shanni11 shanni11 is offline I need to change a formular to overide formula Mac OS X I need to change a formular to overide formula Office 2016
Novice
I need to change a formular to overide formula
 
Join Date: Sep 2016
Posts: 1
shanni11 is on a distinguished road
Default 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).
Reply With Quote
  #2  
Old 09-10-2016, 12:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I need to change a formular to overide formula Windows 7 64bit I need to change a formular to overide formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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.
__________________
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
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft