Thread: IF statement with multiple scenarios.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AMS AMS is offline
external usenet poster
  
Posts: 6
Default IF statement with multiple scenarios.
I am struggling with an IF statement...here's my situation:

I need the default value of a cell (C64) to be 8 as long as cells F24 and
F25 contain text "n". If F24 text is "y" (F25 will remain "n"), then I need
the value of C64 to be (8-I24). If the F25 text is "y" (F24 will remain
"n"), then the value of C64 must be (8+I25). Is this possible to do within
one cell?
Reply With QuoteReply With Quote