View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
57Caddy 57Caddy is offline
external usenet poster
 
Posts: 18
Default Formula referring to another formula

Okay, now I have a more serious question. Say cell B5 equals 6 or greater,
then

=IF(C5=17.5%,5,IF(C5=16.25%,4,IF(C5=14.25%,3,IF (C5=13%,2,IF(C5=0,1,"N/A")))))

and if B5 equals 5 then

=IF(C5=16.5%,5,IF(C5=15.25%,4,IF(C5=13.25%,3,IF (C5=12%,2,IF(C5=0,1,"N/A")))))

and so on down to B5 equaling down to 1 or less.

How do I do this? Forgive me for being kind of a hack.