Help

[eabidh]

Hi can you say what I did wrong here

I want to say

if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25%


thanks

tks

Abidh

(IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)
​

 

[Joe4]

It should look something like this:

[COLOR=#333333][FONT=Verdana]=IF(B1>1384.116,(b1-1384.116)*.7*c1*.25,"")
[/FONT][/COLOR]

Note that you didn't say what you want to happen if if B1 is not greater than 1384.116. We currently have it returning "", but you can replace that with whatever you want.

 

[eabidh]

TKS
BUT
U MISSED OUT THE MINUS SIGN (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

 

[MARK858]

TKS
BUT
U MISSED OUT THE MINUS SIGN (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

If the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25%

You only have one minus sign in your description (which is in red above) and that is in red in the formula from Joe4 below...

=IF(B1>1384.116,(b1-1384.116)*.7*c1*.25,"").

If you mean the other minus in the formula you posted then you haven't included it in your description so Joe4 hasn't missed it! in fact in your description it says multiply.

must be multiplied by 70% of the value in c1.....
(IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

and so you need to describe how it fits in to the rest of the formula as your formula doesn't work.
P.S. please don't use all capitals as it is interpreted as shouting.

 

[Joe4]

If you mean the other minus in the formula you posted then you haven't included it in your description so Joe4 hasn't missed it! in fact in your description it says multiply.

Exactly. I didn't miss it. I saw it, but I went off off your explanation, not your formula, as the formula wasn't working and had errors in it. So I thought your description would be more reliable than the formula attempt.

Be sure to take the time to explain your problem/question in accurate detail. Otherwise, you get results that do what you asked for, rather than what you actually wanted!

 

[eabidh]

Apologies for the caps

apologies for not explaining fully

this is what I came up with and it works for the result I expected

=IF(B1>1384,(B1-1384)-(C1*0.7))*0.25

so if b1 was 1500 my ans is 29

is this the correct way to write te formula or can u improve it / correct it

tks

 

[MARK858]

You haven't put what you want to happen if B1 is less than 1384, at the moment it will give 0.

 

[eabidh]

correct less than 1384 is zero

 

[MARK858]

That's fine then you can leave it as it is or write it as....

=IF(B1>1384,(B1-1384-(C1*0.7))*0.25,0)

(notice that I have removed one set of parentheses, you can leave them in as it doesn't do any harm (and possibly you could argue aids readability) but you don't need them by Excel's rules of precedence).

 

[Dave Patton]

Excel 2010
	B	C
1	1500	0
2	29
3	29
2b

Cell Formulas
Range	Formula
B2	=IF(B1>1384,(B1-1384-C1*0.7)*0.25,0)
B3	=(B1>1384)*(B1-1384-C1*0.7)*0.25