View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default Is it possible to apply IF's to "operator" result..

nastech wrote:
Trying to see how to make separations in formula / find way to
"result" use of operators for an "IF", i.e.:

not working
=IF((CP9)IF($AK$2="u",,<)IF(CP9<CQ9,CQ9,CR9),"U" ,"-")

would be trying to get: CP9CQ9
will cut size of formula in half... thanks



I don't know if I well understand, but try this:

=IF($AK$2="u",CP9IF(CP9<CQ9,CQ9,CR9),CP9<IF(CP9< CQ9,CQ9,CR9))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy