Forum Discussion

lucaparmeggiani's avatar
lucaparmeggiani
Copper Contributor
Aug 10, 2022
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...
  • Patrick2788's avatar
    Patrick2788
    Aug 10, 2022

    lucaparmeggiani 

    You might be using regional settings that has semi colon as the list separator.

     

    Try this one:

    =IF(A1<100;250;500)

Resources