mercredi 18 septembre 2019

proper IF statement issue causing parse error

I am searching for a formula to combine three things. To capture the value of Cell A into cell B. If it has has a number then it should capture that number. If the value of cell A1 is - then it should change to blank in cell B1 and if it has a blank cell in A1 Then it should be blank in B1.

I have tried the formula in google sheet with IF, And OR combining but it is giving an error.

=if(OR(A1="-"," "),(A1=" ", " "))


=if(And(A1="-"," "),(A1=" ", " "))


=IF(A1="-"," ",IF(A1="","",IF(A1=" "," ")))

The expected results are giving an error or it gives the answer as false.

Aucun commentaire:

Enregistrer un commentaire