Hi, I’m having trouble with this excel formula scenario,
I’m wanting cells “M1” and “N1” to be user input.
If “M1” = “T” and “N1” = “5” then = “F1” or if “M1” = “T” and “N1” = “6” then “F2”
or if “M1” = “T” and “N1” = “10” then “F3”
Thanks.
Hi, I’m having trouble with this excel formula scenario,
I’m wanting cells “M1” and “N1” to be user input.
If “M1” = “T” and “N1” = “5” then = “F1” or if “M1” = “T” and “N1” = “6” then “F2”
or if “M1” = “T” and “N1” = “10” then “F3”
Thanks.
Last edited by Markshr; 08-28-2010 at 01:29 AM. Reason: Poor title
Welcome to the forum.
Pleae take a few minutes to read the forum rules, and then amend your thread title accordingly.
Thanks.
Entia non sunt multiplicanda sine necessitate
I am guessing that the latest title is acceptable but it would perhaps be better to revise to something like "Conditional Output"
=IF(M1="T",IF(N1=5,"F1",IF(N1=6,"F2",IF(N1=10,"F3","?"))),"?")
the question marks are to account for situations whereby none of the specified conditions hold true (ie either M1 is not T or N1 is something other than 5,6,10
(if it's not possible for N1 to be something other than 5,6,10 then the above approach can be adjusted accordingly - ie IFs removed)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks