Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
1,312
Views
Topic starter
Hello Friends,
I have a problem if somebody can help, it would be very appreciable. I had wrote many formula but did not get results.
Sample data attached.
We want to exempted values from formula, if any possibility.
Shanu
Posted : 31/05/2017 2:45 am
Hi Shanu
See if this is what you want.
In cell C4 enter :
=IF(A4<60,IF(B4>25000,25000,B4),IF(B4>30000,30000,B4))
Copy the formula down as many rows as needed.
Hope this helps.
Sunny
Posted : 31/05/2017 4:01 am
Topic starter
Thank you Sunny!
It's is not proper working but thank you so much.
When changed age then it is working with this formula. Hope so it should work.
=IF(A4>59.9,IF(B4>30001,30000,B4),IF(B4>25001,25000,B4))
Regards
Shanu
Posted : 02/06/2017 5:54 am