If condition formula required

Raghuram - Jun 12, 2015 at 12:51 PM
 Raghuram - Jun 14, 2015 at 04:04 AM

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:

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