Forum Discussion
Solved
formula
HELLO
GOOD EVENING.
HELP IF POSSIBLE
I wanted to put some conditions to some cells
" if the value of x is less than 100 , the price is 250
If the value of x is greater than 100, the price is 500
how can it be set in a formula? thanks to those who can help
You might be using regional settings that has semi colon as the list separator.
Try this one:
=IF(A1<100;250;500)
5 Replies
- does not take the formula. excel gives error
You might be using regional settings that has semi colon as the list separator.
Try this one:
=IF(A1<100;250;500)
- hi ..I try but I have a doubt .. can I ask you ?
