Hi, everyone. I am new to the excel spreadsheets system and I have a problem imputting a simple formula.
If I type: =IF(H9<1.49,''LAY'','''')
then it says there is an error in the formula. The 'LAY' word starts flashing and I suppose that is the problem.
I would appreciate if you can give me a clue as to what might be the problem. Thanks a lot in advance!
BASIC FORMULA PROBLEM
The problem might be in you Excel settings. Depending on your settings, you need to take a semicolon ";" instead of the comma "," to separate the different constituents of the IF-Formula. Similarly, you might then need to exchange also the decimal point "1.49" by a comma "1,49".
Hope that helps, cheers, F
Hope that helps, cheers, F
Your formula looks fine to me.
However, I noticed you have used double single quotes (') rather than a single double quote (").
It is important you use the latter.
Regarding the decimal separator, this depends upon your regional version and settings.
However, I noticed you have used double single quotes (') rather than a single double quote (").
It is important you use the latter.
Regarding the decimal separator, this depends upon your regional version and settings.