LinkBack URL
About LinkBacks
This is my current formula and it works fine except when value f40= 100. I just want to add in an iff40=100 then rept "|",100.=IF(F40<100,REPT("|",F40-1)&F40&"%"&REPT("|",100-F40-1),REPT("|",100-1)&F40&"%"&REPT("|",100-100-1)&"*")
This is my current formula and it works fine except when value f40= 100. I just want to add in an iff40=100 then rept "|",100.=IF(F40<100,REPT("|",F40-1)&F40&"%"&REPT("|",100-F40-1),REPT("|",100-1)&F40&"%"&REPT("|",100-100-1)&"*")
Resolved
Just added the if statement
IF(F40=100,REPT("|",100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks