Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I tell Calc (or Excell) to display one figure in one case, or another figure if another case?
I need a formula that says "Look at cell B12. If it's less than 6, then display 1. If it's between 7 and 20, then display 1.5. If it's between 20 and 30 then display 2."
Is there a way to do this that I'm missing?
Garbo that's almost exactly what I tried, and Calc keeps coming back with #NAME?
For reference, this is what it looked like after I changed it from the example: =IF(I4="","",IF(I4<6,1,IF(AND(I4>6,I4<21),1.5,IF(AND(I4>19,I4<31),2))))
Eh, it didn't keep the whole thing...but you get the idea.
3 Answers
- garbo7441Lv 71 decade agoFavorite Answer
Edit: I don't use Calc, so I am not familiar with its syntax. However, it does not appear the 'IF', 'And', or 'Between' are included in its built in functions.
Please see this site:
http://isthe.com/chongo/tech/comp/calc/calc-builti...
The formula is:
=IF(B12="","",IF(B12<6,1,
IF(AND(B12>6,B12<21),1.5,
IF(AND(B12>19,B12<31),2))))
If cell B12 is blank, the formula result is also blank, else it returns the value resulting from the formula.
Note: This formula should be entered all in one line.
- expletive_xomLv 71 decade ago
Garbo's formula logic is correct and will work.
its default OoCalc, so you need to replace all the commas with semi-colons when you write your formulas.
i know it wierd, but you get used to it.
edit:
or copy&paste this
=IF(I4="";""; IF(I4<=6;1;IF(I4<=20;1.5;2)))
and it should work.
- 1 decade ago
I haven't used that in forever, but I wanted to give you props for using OpenOffice.org
