I am trying to create a formula that is conditional on the text in another cell and completes a simple calculation using a value from yet another cell. For example I have a dropdown for cell a2 that has options of A,B,C. If A2 ="A" then I want it to use the value entered in C2, If A2= "B" I want it to divide the value in C2 by 2, If A2 = "C" then I want the value to be 0. I have tried and tried and know I am close but can't get it to work. Please help
try
=IF( A2="A", C2, IF(A2="B", C2/2, IF(A2="C", 0, "" )))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Worked perfectly! Thanks. I see now where I was messing up.
your welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks