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)))))

If condition formula required
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

1 response

Answer 1 / 1

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.

Raghuram
Jun 14, 2015 at 04:04 AM

Thank you Verymuch.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

A required download missing

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!