Hello
i need to do a conditional function. i am not sure if is conditional.
I explain you what i want
in a cell i put a value, and next cell have a function which depends on that value. ej if A1=<50, B1=A1*1,09; if A1=between 50 and 150, B1=50*1,09+((A1-50)*0,91); if A1>150, B1= 50*1,09 + 100*0,91 + (A1-150)*0,73 or
if A1=<50, B1=A1*1,09; if A1=between 50 and 150, B1=54,50+((A1-50)*0,91); if A1>150, B1= 145,50+ (A1-150)*0,73
Thanks in advance.
=IF(A1>150;145,50+(A1-150)*0,73;IF(A1>50;54,50+((A1-50)*0,91);A1*1,09))
You may need to replace with IF with SI for Spanish version.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
If you have more tiers to add you may prefer to adopt a SUMPRODUCT based approach, eg:
(I believe SUMPRODUCT translated would be SUMAPRODUCTO)
=SUMPRODUCT(--(A1>{0\50\150});A1-{0\50\150};{1,09\-0,18\-0,18})
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
or
=CHOOSE(MATCH(A1;{0;51;151}); A1*1,9; 54,5+((A1-50)*0,91); 145,5+(A1-150)*0,73)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks