Dear excel-forum members,
Unfortunately I'm not able to insert a excel ceiling function in a 'if' function (true).
=IF(C7<=B1;"ceiling((B1-C7)/$B$3)";0) gives the whole string but not the answer.
I attached an Excel file so you can check it out.
Dear excel-forum members,
Unfortunately I'm not able to insert a excel ceiling function in a 'if' function (true).
=IF(C7<=B1;"ceiling((B1-C7)/$B$3)";0) gives the whole string but not the answer.
I attached an Excel file so you can check it out.
Something like this?
![]()
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks