ExcelBanter - Data Validation - Custom

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation - Custom - Formula (https://www.excelbanter.com/excel-worksheet-functions/24396-data-validation-custom-formula.html)

DYeomans

Data Validation - Custom - Formula

I need to create a Formula for the following:

=b10 to start formula

The formula should determine that the value in cell B10 is less than or
equal to 150% of the value in cell B9.

Any help with this would be greatful, this is part of an homework assignment.

Thanks

Vasant Nanavati

=B10<=1.5*B9

will return TRUE or FALSE.

--

Vasant

"DYeomans" wrote in message
...
I need to create a Formula for the following:

=b10 to start formula

The formula should determine that the value in cell B10 is less than or
equal to 150% of the value in cell B9.

Any help with this would be greatful, this is part of an homework
assignment.

Thanks

DYeomans

Thank you! This had me for the last week!

"DYeomans" wrote:

I need to create a Formula for the following:

=b10 to start formula

The formula should determine that the value in cell B10 is less than or
equal to 150% of the value in cell B9.

Any help with this would be greatful, this is part of an homework assignment.

Thanks

All times are GMT +1. The time now is 06:37 PM.