Please tell me the formula. He is already tired and there is not enough time.

Condition: there is a column with tsinirikami "pancake" the whole column -5% is needed, then if the number is from 0 to 999 then + 58%, if from 1000 to 9999 then + 48%, and if more than 10,000 then + 43%. I tried it many times, but then the brackets are not there, then commas. I'm already confused. Help, please, I am burning.

  • What did you want to say? Understood nothing. My understanding ended up on this brain-bearing phrase, like Russian letters: "there is a column with digits" pancake "the whole column -5% is needed." - pincher1519

1 answer 1

=A1*ЕСЛИ(A1*0,95>10000;1,43;ЕСЛИ(A1*0,95>1000;1,48;1,58) =ВПР(A1;{0;1,58:1000;1,48:10000;1,43};2;1) 
  • And if this is not just a number but a result by the formula, then it’s probably something else is needed, right? = MUMNAGE (RC [-1]; 0.95) Help, if it's not difficult, please !!! I try changing A1 to RC {- 1} Does not Help !!! - oleg007
  • R1C1 or A1 is just a notation and changes in Excel settings - uncheck the checkbox "File-> Options-> Formulas-> Style R1C1" and everything will be A1 - Barmaley
  • DEC KAKOITO REALLY CAN'T ... MAY HOW MORE THAN 1 DAY IN EXCEL "E WHICH CHEBOX:) AND IN THE FILE NO LINE PARAMETERS:) I CAN" NUBLY "IF MY QUESTION IS MORE INTERESTED TO SOMEONE, PROMPT YOUR WOMEN VOID.
  • The only thing that could do all this but in three wards and manually, in one day, progress can also, but the teacher is not satisfied. I can separately make formulas for three conditions if the formulas were scored manually, and the positions are 2000, but you don’t have to overlook where 12 where is 1122 and where is 23422, in general, all this is not accurate, but I have not yet figured out how to infuse one formula - oleg007
  • @Barmaley if sclerosis does not change me, then RC [-1] is a relative address (one column less. Unlike R1C1, which is A1. - alexlz