ExcelBanter - function problem

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

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

- - function problem (https://www.excelbanter.com/excel-worksheet-functions/239782-function-problem.html)

SCP

function problem

I have A1 and A2
subtract A2 from A1
my problem lies when those numbers fall between 12 - 12.50
I need it to still subtract them but if it falls between there, I need to
additionally subtract another .50
wherever this falls, is a completely random column

Is there a formula for somthing like this?

T. Valko

function problem

One way:

=A2-A1-(AND(A1=12,A2<=12.5)*0.5)

--
Biff
Microsoft Excel MVP

"Scp" wrote in message
...
I have A1 and A2
subtract A2 from A1
my problem lies when those numbers fall between 12 - 12.50
I need it to still subtract them but if it falls between there, I need to
additionally subtract another .50
wherever this falls, is a completely random column

Is there a formula for somthing like this?

All times are GMT +1. The time now is 12:45 PM.