Forum Discussion

dennis houle's avatar
dennis houle
Copper Contributor
Nov 01, 2017
Solved

IF AND function

Hello, I need help with a couple formulas.   In one case, If cell $C18 and $X18 both have data, then apply the formula but if either is blank, then leave the cell with the formula blank.  So this i...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 01, 2017

    Dennis, if with one column

    =X3-IF(LEN(C3)=0,Y3,Z3)
Anonymous's avatar
Anonymous
Nov 01, 2017

Hi

hope i got your question right,i think that a nested is Better

=if($C18="",if($x18="","","put here the AA18 formula"),if($X18="","","put here the condition for C18 not blank"))

couldnt find the attchment

Yossi

 

Resources