If statments for LibreCalc

[JohnDoe558]

I need to create If statements that works across two columns.

Suppose if I have two columns A and B, I need to enter data in A and it should automatically enter the corresponding value of that data into B.

The values in column A are percentage based and only two, 100% and 150%. Each of those values represent distinct values. 100% will always mean 12500 and 150% will always mean 18750.

I need both the conditions at the same time as I may enter either of the values in Column A (and sometimes not at all, I can skip some cells as well). Column B should also be empty (no 0 is no value, but empty cells) unless I enter the value in A.

I tried making an If statement, but it only works for one condition ( I don’t know how to make two If conditions) and If there is no value in A, then the subsequent cell in B is filled with 0, which is not what I want.

Thank you for your help!

[karolus]

Hallo

=IF(A1;A1*12500;"")

and pull down.

[LeroyG]

If I understood, the formula coud be: =IFNA(IFS(A1=1;12500;A1=1.5;18750);"")

Beware that 100% = 1, and 150% = 1.5.

See the sample file:
IFS_84857.ods (11.4 KB)

LibreOffice Help on IFS and IFNA.

See a related question about the formula empty results: Find a blank non-empty cell

[Jotra]

Would
=IF(ISBLANK(A2),"",IF(A2=100,12500,18750))
do the job you want? It assumes only two possibilities for the value in A2,
if other values could exist, maybe
=IF(ISBLANK(A2),"",A2*125)
would be an alternative.