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...
You might be using regional settings that has semi colon as the list separator.
Try this one:
=IF(A1<100;250;500)
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)- THANKS 🙂