If condition formula required

Solved/Closed
Raghuram - Jun 12, 2015 at 12:51 PM
 Raghuram - Jun 14, 2015 at 04:04 AM
Hello,

Thank for the earlier reply.

Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. of days mentioned in the formula from a particular column(V6) where total no of days are given. if AB2=0, then it should display "0"). i tried but not getting the result.

=IF(AB6>=1, V6-28,IF(AB6>=2, V6-59,IF(AB6>=3, V6-89,IF(AB6>=4, V6-120,IF(AB6>=5, V6-150, 0)))))


1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 12, 2015 at 05:43 PM
Raghuram, Good evening.

Try to use:
=IF(AB2=0,0,IF(AB2>=5,V6-150,IF(AB2>=4,V6-120,IF(AB2>=3,V6-89,IF(AB2>=2,V6-59,V6-28)))))

Is it what you want?
I hope it helps.
0
Thank you Verymuch.
0