LinkBack URL
About LinkBacks
hi Guys,
i tried to calculate if a cell contains more than 50 km than the result must be "cost"
I don't get a result if i use If function because maybe it's a tekst or something.
see attachment
hi Guys,
i tried to calculate if a cell contains more than 50 km than the result must be "cost"
I don't get a result if i use If function because maybe it's a tekst or something.
see attachment
Last edited by Framboosje; 11-24-2017 at 06:47 AM.
Try
=IF(SUBSTITUTE(SUBSTITUTE(F4," km";""),"m","")+0>50;"Yes","No")
Sorry ... missed request for title change
Try
g4Formula:
Please Login or Register to view this content.
Copy down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks