If condition formula required

[Solved/Closed]
Report
-
 Raghuram -
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 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.
Thank you Verymuch.