Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
need to save values from a function before it changes | Excel Worksheet Functions |