Using two separate scenarious in one IF function
 

Can I have more than one scenario in an IF function that are not dependent on
each other:

If (F275, (F2-75), (0), IF (E2675, (E26-75), (0))

Hi

What about F275 AND E2675 ?

When above never happens, then
=MAX((F275)*F2+(E275)*E2-75,0)


Arvi Laanemets


"klgcm" wrote in message
...
Can I have more than one scenario in an IF function that are not dependent
on
each other:

If (F275, (F2-75), (0), IF (E2675, (E26-75), (0))

So ...
Are you saying that you want both the scenarios evaluated in the same cell,
regardless of outcome?

You could use something like this:
=((IF(F275,F2-75,0))&" "&(IF(E2675,E26-75,0)))
this would put 3 spaces between the two answers.

This one:
=((IF(F275,F2-75,0))&CHAR(10)&(IF(E2675,E26-75,0)))
would put the answers on separate lines in the same cell, if you turn on
Cell Wrapping from Format|Cells, on the Alignment Tab.

tj

"klgcm" wrote:

Can I have more than one scenario in an IF function that are not dependent on
each other:

If (F275, (F2-75), (0), IF (E2675, (E26-75), (0))