IF Statement problem

M

MarkFrost39

Hi
I have got a problem with an If Statement that I am trying to create.
Cell A1 is a variable number (but I will use -24, for the example)

A3 = -9
A4 = -15
A5 = -3
A6 = -11
A7 = -7
A8 = -1
A9 = -13
A10 = -5
A11 = -17
A12 = -4
A13 = -6
A14 = -14
A15 = -12
A16 = -10
A17 = -2
A18 = -16
A19 = -8
A20 = -18

The formula that I need to create is basically the following that I need to
nest together.
If Cell A1 is higher than -18 (this is lower in negative form, -19 etc)
=IF(A1<-18,IF(SUM(A3-18)=>A1,2,IF(SUM(A3-18)<A1,0))
If Cell A1 is Lower than -18 (this is higher in negative form, -17 etc)
=IF(A1>-18,=IF(A3=<A1,1,IF(A3>A1,0))

The final pieces of the Jigsaw are:
If Cell A1 is equals to 1.
=IF(And(A1=1,A3=-18,-1,0)
If Cell A1 is equals to 2.
=IF(And(A1=2,A3=-18 or -17,-1,0)

I will then copy the formula down to A20

I hope that this makes sense

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement problem 3
Problem with If Statement 0
how to use an formula to transpose a list(left) to be like the right? 2
Using two Vlookup in one Cell 1
Need help calculating probabilities 7
If & Vlookup statement 3
Cumulative formula for word table 0
Formula to answer YES or No 4

Top