Can anyone kindly assist me me in writing an IF and ROUNDOWN formula.
In row 7 of the atatched spreadsheet I have given the answer required.
I basically have a certain numnber of colleagues to fill vacancies by grades.
There is further explanation in the spreadsheet.
Thanks
Hi
Not sure if this is what are you asking for.. Do you mean?
=IF(D4<>"",ROUND(D4;0),"")
This gives you 7 for D4 which is 7.3
edit:=IF(D4<>"",ROUND(D4,0),""
Last edited by Fotis1991; 07-03-2012 at 08:05 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Even with the attached sheet your explaination is a little vague, try the formula in B7 then fill to the right.
=IF(K4,ROUNDDOWN(B4,0),"")
The answer for EU appears to break your rounddown rule
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks