I am using Numbers to help with my payroll.
1.If a number in column D is 150, then I want F to say INS.
2.If a number in column E is 25 or greater, I want column F to say 25.
3.If a number in column E is less than 25, I want column F to say whatever that number is.
I can get it to do 2 and 3 just fine, things get messed up when I try to add in item 1.
Please help!
—–
Jakey
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Nest IF Formulas Taking Data From 2 Different Columns?
Comments: One Response to “How Do I Nest IF Formulas Taking Data From 2 Different Columns?”
Comments Closed.
Just nest them, like you suggest:
=IF(D2=150,"INS",IF(E2>=25,25,E2))
The first IF has the parameters condition,true,false. So if D=150 then you want "INS" as the value. If not, then you want to put another IF statement as the false value. That one checks the value of E.
This assumes that you want INS when D is 150 no matter what E is. Otherwise, you'd have to nest them in a different order.