IF Function or IF then else

K

klgcm

I want to use an If function that meets one situation and if that doesn't
work I want to use a second If function in the same cell, but the second
situation has nothng to do with the first situation

eg; If (F2>75, (F2-75), (0), If (E26>75, (E26-75), (0))

Can this be done?
 
B

Bob Phillips

do you mean?

=If (F2>75, F2-75, If (E26>75, E26-75, 0))

You can't always test both conditions, if the fist is met, the second
doesn't get evaluated.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using two separate scenarious in one IF function 2
Excel - Wich Function should I use? 1
Would like to input 3 letters into a cell, each having a different numerical value 5
how to find out the grade from marks-functions 7
Count function without double counting 1
How do I count the number of entries of specifc criteria is met 2
Calculate running average but not count a zero. 3
Return Function 2

Top