How would I write a formula to show (for example) the contents of A3 in A1 if A2 is within a stated bracketed value relative to A4?
For example inputting in A1, IF(A2=+-1ofA4;A3;"") The "+-1ofA4" bit is what I don't know. The result should be if the number in A2 is plus or minus 1 from the value in A4 then A3 is shown in A1, otherwise blank.
Thanks.
[Solved] How should I write this IF() formula?
[Solved] How should I write this IF() formula?
Last edited by Veda on Sat Aug 11, 2018 10:24 pm, edited 2 times in total.
Win 10, open office 4.1.5
Re: How should I write this IF() formula?
IF(ABS(A2-A4)<=1;A3;"")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: "SOLVED" How should I write this IF() formula?
Perfect, Thanks a lotVilleroy wrote:IF(ABS(A2-A4)<=1;A3;"")
Win 10, open office 4.1.5