View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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))