CODEWITHSUNDEEP
excelfunctiontext
Laurcons
Laurcons

Reputation: 5

Excel Function Error

I am trying to create a cell from a Excel to show three values depending of a number from another cell. The function I use is =IF(H4<100;(TEXT(Probabil));(IF(H4<50;(TEXT(Sigur));(TEXT(Da))))

NOTE: The function outputs are in Romanian. Probabil means possible, Sigur means sure and Da means yes.

I tried to use " before and after the string values. I tried to put ( and ) before and after the TEXT functions and it resulted to the function above.

I saw in the function syntax =TEXT(String;Type). I think the Type is required... what values can I put in that place?

Upvotes: 0

Views: 44

Answers (1)

Solar Mike
Solar Mike

Reputation: 8385

From what I understand that you are trying to achieve, the logic is wrong. I would suggest =IF(H4<50;"Sigur";IF(H4<100;"Probabil";"Da")) Note I removed the "text" function - the double quotes are enough.

Upvotes: 2

Related Questions