If Nested Function In Excel

[aziz]

I have categorised the numbers into (H) Hot, A(Average), C(Cold).
0 appearance = C (Cold)
1-2 appearance = A (Average)
3> appearance = H (Hot)

could somebody help me with the IF Nested Function.

tq

 

[lottomaniac649]

Hi aziz;
You try this one. If(range=0,"C"),IF(range<=2,"A"),if(range=>3,"H")
Bye
LM649

 

[GillesD]

Nested functions

Lotto maniac

I am not too sure what version of Excel you use, but personnally, I would use this formula with Value being a cell with the result of the calculations or a function that returns a number:

=IF(Value=0,"C",IF(Value=1,"A","H"))

 

[aziz]

'=IF(R195=0;"C");IF(R195<=2;"A");IF(R195>=3;"H")).
sorry guys but I got the result as "#VALUE?", by the way I'm using excel 2003

pl help

tq

 

[GillesD]

Nested IF

aziz

The formula you used is not mine but depending on the configuration of your Excel (any version), one of these two formulas will give you the answer you want:

=IF(R195=0,"C",IF(R195=1,"A","H"))
or
=IF(R195=0;"C";IF(R195=1;"A";"H"))

The only difference between the two formulas is the separator between arguments; the first one uses a comma (,) as separator and the second one a semicolon (. You may want to used the Insert function on your toolbar to insert the function.

 

[aziz]

TQ Mr GillesD

 

[lottomaniac649]

Lotto maniac

I am not too sure what version of Excel you use, but personnally, I would use this formula with Value being a cell with the result of the calculations or a function that returns a number:

=IF(Value=0,"C",IF(Value=1,"A","H"))

Hello GillesD;
I think I've not spelt out correctly. What I did mean was the cell which contain a value(range). You're a Master! but myself just a starter. Y/d I was trying to post a problem in my macro where there's a loop; but somehow I myself after seeing a book sorted out. I'm thinking of your help/opinion to finalise my excel template for all lotto game predictions.
Thanks!
LM649

 

[srestha1968]

Hi aziz;
You try this one. If(range=0,"C"),IF(range<=2,"A"),if(range=>3,"H")
Bye
LM649

Hi lottomaniac649,
I am from India, Kolkata, found you that u have had created a good kinda software in ms-excel for lotto. I am interested in joker, keno,lucky3+...can u help me with ur software.....i am good at excel but can't do macros....i have went thru some of ur threads where u have been in touch with mr.gillesD and find the same very intt. since u deal with sikkim super lotto, therefore i would like to get help from u in this regard. Thanks in advance. My email is <<< email addys are not allowed >>>

Regards,
Srestha