The rates are 0-7999 gives 40%, 8000 - 11999 gives 45%, 12000 - 16000 gives 50% and 16000+ gives 55%. I was trying to use a multiple IF statement but getting bogged down. Any sensible help would be appreciated . Cell B20 would have the value 0 - 16000+ and Cell B21 would have output 40%, 45%, 50% or 55%
2007-01-11 21:22:30 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
This should do the trick.
=IF(B20< 8000,40, IF(B20< 12000, 45, IF(B20 <16001 ,50, 55)))
2007-01-11 21:28:15 · answer #1 · answered by mark 7 · 1⤊ 0⤋
Many common natural remedies are claimed to have blood sugar lowering properties that make them useful for people with or at high risk of diabetes. Learn here https://tr.im/rUtHb
A number of clinical studies have been carried out in recent years that show potential links between herbal therapies and improved blood glucose control, which has led to an increase in people with diabetes using these more 'natural' ingredients to help manage their condition.
2016-05-03 04:16:50 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Hi There Are you trying to get 40% of the value in cell b20. Something like this might work.
=IF(B20<8000,B20*0.4,
IF(B20<12000,B20*0.45,
IF(B20<16000,B20*0.5,B20*0.55)
))
2007-01-11 21:38:09 · answer #3 · answered by Joe H 2 · 1⤊ 1⤋
The formula you need is this:
IF(B20<=7999,40%, IF(B20<=11999,45%, IF(B20<=16000,50%,55%)))
Put this formula in cell B21
Trust this helps
J
2007-01-11 21:34:15 · answer #4 · answered by jamiehall34 2 · 0⤊ 1⤋
Steve : You have altered your question. I feel that I gave an acceptable answer earlier today. It takes time to type If statements. I tested my previous entry and feel that it works.
2007-01-12 02:55:10 · answer #5 · answered by Como 7 · 1⤊ 0⤋