Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Fahimah Khan   on Aug 31 In MS Office Category.

  
Question Answered By: Jana Franklin   on Aug 31

I'm not sure if you want B12 to just return "Poor Hitter" or "Poor Hitter" plus
the batting average  (ditto for B13 and "Good Hitter"). The following formulas
return the label plus the batting average:

B12: =IF($A$10=0,"",IF($A$11/$A$10<=0.25,"Poor Hitter " &
TEXT($A$11/$A$10,".000"),""))

B13: =IF($A$10=0,"",IF($A$11/$A$10>0.25,"Good Hitter " &
TEXT($A$11/$A$10,".000"),""))

Or, you could do it all in one cell: =IF($A$10=0,"",IF($A$11/$A$10<=0.25,"Poor
Hitter "& TEXT($A$11/$A$10,".000"), "Good Hitter "& TEXT($A$11/$A$10,".000")))

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Any idea how to write formula? Or get search suggestion and latest updates.


Tagged: