ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If Function (https://www.excelbanter.com/excel-worksheet-functions/11505-if-function.html)

meekone

If Function
 
I'll try to explain this
I have a value in Cell A either <25.01, <1000.01 or 1000.00 If the value in
A returns true to <25.01 then Cell B value = A*.0325, if the value in A
returns true to <1000.01 then Cell B Value=A*.02, and if the last value
returns true then B=A*.01
How do I write this?

Harlan Grove

meekone wrote...
I have a value in Cell A either <25.01, <1000.01 or 1000.00 If the

value in
A returns true to <25.01 then Cell B value = A*.0325, if the value in

A
returns true to <1000.01 then Cell B Value=A*.02, and if the last

value
returns true then B=A*.01
How do I write this?


Your second and third tests are redundant. Replace the second test with
<=1000. Once done, the third test will necessarily be true if the
second is false. It's a mathematical necessity. So, try

=A*IF(A<=25,0.0325,IF(A<=1000,0.02,0.01))



All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com