Hi!
Looking for some help with a nested formula (or an alternative method to achieve the same task) for following:
I have two blank cells - C12 and C13. Depending on the inputs of these cells, I require a set output in cell C15.
Result required in C15 to be determined from inputs as below:
C12 In_______C13 In______C15 Out
___1____________2________Kentec XT
___1____________4___Kentec XT+ 1 Area 4 Zone
___1____________6___Kentec XT+ 1 Area 8 Zone
___2____________2___Kentec XT+ 2 Area 2 Zone
___2____________4___Kentec XT+ 2 Area 4 Zone
___2____________6___Kentec XT+ 2 Area 8 Zone
___3____________2___Kentec XT+ 3 Area 2 Zone
___3____________4___Kentec XT+ 3 Area 4 Zone
___3____________6___Kentec XT+ 3 Area 8 Zone
___4____________2___Kentec XT+ 4 Area 2 Zone
___4____________4___Kentec XT+ 4 Area 4 Zone
___4____________6___Kentec XT+ 4 Area 8 Zone
Where the conditions above are not met (FALSE), C15 should report "Please enter correct information above".
Have tried nesting IF AND formula but a little beyond my level of EXCEL!!
Any help would be hugely appreciated.
Bookmarks