Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simple formula
I want to find out the difference between two numbers and if its more than
certain amount identidy it. Eg. -1.3445 , 1.4554, the difference between these two nos, should be less than 0.1 . but when i try to write the if formula dosent wrk out the way i wanted. i did these functions several years ago, i was wondering am i missing something or function wont work with minus nos. ????? Helpppppppppp...... |
#2
|
|||
|
|||
simple formula
Why not give us your formula and the results?
=IF(B1-A1<0.1,"","Too much difference!") -- Kind regards, Niek Otten "amharan" wrote in message ... I want to find out the difference between two numbers and if its more than certain amount identidy it. Eg. -1.3445 , 1.4554, the difference between these two nos, should be less than 0.1 . but when i try to write the if formula dosent wrk out the way i wanted. i did these functions several years ago, i was wondering am i missing something or function wont work with minus nos. ????? Helpppppppppp...... |
#3
|
|||
|
|||
simple formula
I was trying to put -0.1 in the formula thats giving me wrong answer but 0.1
woks fine thank you. "Niek Otten" wrote: Why not give us your formula and the results? =IF(B1-A1<0.1,"","Too much difference!") -- Kind regards, Niek Otten "amharan" wrote in message ... I want to find out the difference between two numbers and if its more than certain amount identidy it. Eg. -1.3445 , 1.4554, the difference between these two nos, should be less than 0.1 . but when i try to write the if formula dosent wrk out the way i wanted. i did these functions several years ago, i was wondering am i missing something or function wont work with minus nos. ????? Helpppppppppp...... |
#4
|
|||
|
|||
simple formula
Maybe better:
=IF(ABS(B1-A1)<0.1,"","Too much difference!") -- Kind regards, Niek Otten "amharan" wrote in message ... I was trying to put -0.1 in the formula thats giving me wrong answer but 0.1 woks fine thank you. "Niek Otten" wrote: Why not give us your formula and the results? =IF(B1-A1<0.1,"","Too much difference!") -- Kind regards, Niek Otten "amharan" wrote in message ... I want to find out the difference between two numbers and if its more than certain amount identidy it. Eg. -1.3445 , 1.4554, the difference between these two nos, should be less than 0.1 . but when i try to write the if formula dosent wrk out the way i wanted. i did these functions several years ago, i was wondering am i missing something or function wont work with minus nos. ????? Helpppppppppp...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |