Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=if QUESTION
THIS IS WHAT I WOULD LIKE TO DO:
IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
#2
|
|||
|
|||
Colin2u,
In K42 IF (I30<=K39*0.75,(K39-I30)*0.5,"") Henry "Colin2u" wrote in message ... THIS IS WHAT I WOULD LIKE TO DO: IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
#3
|
|||
|
|||
One way, if I understand correctly:
K42: =IF(I30<=K39*99.75%,0.5%*(K39-I30),"") In article , "Colin2u" wrote: THIS IS WHAT I WOULD LIKE TO DO: IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
#4
|
|||
|
|||
Is this what you want?
=IF(K39-I30=K39*0.25,(K39-I30)/2,"") If not supply some numbers and the answer you want. Peter "Colin2u" wrote: THIS IS WHAT I WOULD LIKE TO DO: IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
#5
|
|||
|
|||
JE,
Oooops! I didn't spot the decimal points. If he really meant them to be there it would have been clearer to have put 0.25% and 0.5%. Henry "JE McGimpsey" wrote in message ... One way, if I understand correctly: K42: =IF(I30<=K39*99.75%,0.5%*(K39-I30),"") In article , "Colin2u" wrote: THIS IS WHAT I WOULD LIKE TO DO: IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
#6
|
|||
|
|||
Colin2u,
To clear this up, by .25% do you mean a quarter or a quarter of 1%(=1/400th)? By .50% do you mean a half or a half of 1%(=1/200th)? Henry "Colin2u" wrote in message ... THIS IS WHAT I WOULD LIKE TO DO: IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO BE PLACED IN K42. SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Compare Question | Excel Worksheet Functions |