Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I don't understand How I can calculate some examples. See below.
if (a>0, 'b*0,1', 'b*0,15')
I see result b*0,1, but I want calculate it. For example 3*0,1 and result = 0,3.
How I can do it? Help me, please.
Many thanks,
Yuriy
Whats the condition your looking for ? could you please explain bit more
if(a>0 , b*0.1 , b*0.15 )
so this evaluate like this ....
if a >0 , then b multiple 0.1 and if a not >0 then b multiple 0.15
Hope this helps you
Remove the quotes.
Replace the comma by a dot. Only a hand full of countries use the comma as a decimal separator, the rest of the world (or at least the programming world) uses a dot. Confusing, I know; I live in a country that uses the comma.
here is an example
The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.
Example:
if( Amount>= 0, 'OK', 'Alarm' )
Thanks, but it doesn't work.
I have the same result b*0.1, but I want receive 0.3 (b*0.1=3*0.1).
Have you any another ideas?
Whats the condition your looking for ? could you please explain bit more
if(a>0 , b*0.1 , b*0.15 )
so this evaluate like this ....
if a >0 , then b multiple 0.1 and if a not >0 then b multiple 0.15
Hope this helps you
Thank you a lot! It works.
Many thanks,
Yuriy
So what I suggest does not work, but when Avinash suggests (in my opinion) exactly the same it does all of a sudden work?
Could you explain the difference as I am probably overlooking the obvious.
okg probably the example made a difference but yes yours and mine suggestion are one and the same
Yes, of course. Example help me. I was careless and forgot remove quotes, that's why I had a negative result(((
Of course, you answer is right and the same.
Sorry for my careless. Thank you for help.