ExcelBanter - IF Function or IF then else

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function or IF then else (https://www.excelbanter.com/excel-worksheet-functions/5861-if-function-if-then-else.html)

IF Function or IF then else

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 (F275, (F2-75), (0), If (E2675, (E26-75), (0))

Can this be done?

do you mean?

=If (F275, F2-75, If (E2675, 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)

"klgcm" wrote in message
...
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 (F275, (F2-75), (0), If (E2675, (E26-75), (0))

Can this be done?