Forum Discussion
lucaparmeggiani
Aug 10, 2022Copper Contributor
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...
- Aug 10, 2022
You might be using regional settings that has semi colon as the list separator.
Try this one:
=IF(A1<100;250;500)
Patrick2788
Aug 10, 2022Silver Contributor
lucaparmeggiani
Aug 10, 2022Copper Contributor
hi ..I try but I have a doubt .. can I ask you ?