Too many arguments (IF function)

[mcwain]

I'm not an expert, and have never used nested IF functions. Please could an expert help me.

This is what I need:
If F6 is greated than 0 (zero) then add the value of D6, if this statement is false, then I want the value 0 (zero). My formula will work this far

I also need: IF B6 is less than F6, I need the word "NIL" to come up, If this statement is false then I want the value of E6.

Below is my effort:

=IF(AND(F6>0,D6,0),B6<F6,NIL,E6)

 

[VoG]

The board software has truncated your formula. Try reposting it with spaces before and after any < or >

 

[mcwain]

I'm not an expert, and have never used nested IF functions. Please could an expert help me.

This is what I need:
If F6 is greated than 0 (zero) then add the value of D6, if this statement is false, then I want the value 0 (zero). My formula will work this far

I also need: IF B6 is less than F6, I need the word "NIL" to come up, If this statement is false then I want the value of E6.

Below is my effort:

=IF(AND(F6 > 0,D6,0),B6 < F6,NIL,E6)<F6,NIL,E6) div <>

 

[VoG]

Maybe

=IF(B6 < F6,"Null",IF(F6 > 0,D6,0))<f6,"null",if(f6></f6,"null",if(f6>

 

[mcwain]

It came up null when wanted, however, I got a figure of 1344% no matter what figures I put in B6.

Better than I got though.

Anymore help would be appreciated

 

[mcwain]

Or more to the point, if:
the value in D6 is £300 it comes up with 3000%, when the value should be 100%

 

[mcwain]

Regarding the Maybe solution
when D6 is £74, for example, 7400% comes up. When D6 is £240 it comes up with 24000%, when the answer should have been 100%.

Any ideas

 

[mcwain]

It's OK now. My fault.

Many thanks to Peter. You are a superstar.

Mike