SOLVED

formula

New Contributor

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

5 Replies

@lucaparmeggiani 

With those conditions, you might use:

=IF(A1<100,250,500)
hi ..I try but I have a doubt .. can I ask you ?
does not take the formula. excel gives error
best response confirmed by Grahmfs13 (Microsoft)
Solution

@lucaparmeggiani 

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

 

Try this one:

=IF(A1<100;250;500)
THANKS