Thread: Easy one? Is there a "When" like argument?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xcelentform[_3_] xcelentform[_3_] is offline
external usenet poster
  
Posts: 1
Default Easy one? Is there a "When" like argument?

Here is an easy one for someone smarter than I: If Cell A1=2 and Cell
B1=2 and Cell C1=A1+B1, currently equally 4. I am trying to find or
create a formula in Cell D1 that would argue:D1=WHEN(A1=10,C1=12) I am
trying to get a 12 kicked out in the above scenario. This is similar to
an IF statement, but if you plug IF in we know it will return a false
value. Any ideas or solutions?


--
xcelentform
------------------------------------------------------------------------
xcelentform's Profile: http://www.excelforum.com/member.php...o&userid=16889
View this thread: http://www.excelforum.com/showthread...hreadid=504168

Reply With QuoteReply With Quote