Formula: Simple but complex for me

[BillV]

Can someone help me build a formula that will do this:

Always subtract the smaller number from the larger number
IF B26 is greater than B30 then subtract B30 from B26
IF B30 is greater than B26 then subtract B26 from B30
If the result is less than 59 OK
If the result is greater than 300 OK
Anything else ALERT

 

[dialup]

try

=IF(B26-B30 > 0,B26-B30 ,B30-B26)

sorry only read the 1st bit - i'll look at the second criteria

 

[BillV]

Can you give me the whole enchilada?

 

[jerel1429]

You might need two cells to do this. Try this:

In cell B32: =IF(B26>B30,B26-B30,B30-B26)
In cell B33: =IF(OR(B32<59,B32>300)=TRUE,"OK","ALERT")

 

[Scott Huish]

You should be able to do it in one cell:

=IF(OR(ABS(B26-B30)<59,ABS(B26-B30)>300),"OK","ALERT")

 

[dialup]

this works put it in any cell

=IF(IF(B26-B30 > 0,B26-B30,B30-B26) <59,IF(B26-B30 > 0,B26-B30,B30-B26),IF(IF(B26-B30 > 0,B26-B30,B30-B26) >300,IF(B26-B30 > 0,B26-B30,B30-B26),"ALERT"))

 

[BillV]

Each of these formula's seem to be close. I probably didn't provide the best explanation. Hotpepper's formula is more of what I expected. I need to do more testing. I'll come back if I need additional help. Thanks to everyone!