I know this is a very basic query, but I just can't figure it out! The following forumula doesn't recognise kg, even when the cell contains kg. Cell D87 is formatted for text (I have also tried other formats to no avail).
=IF(ISBLANK(E87),"",IF($D87="kg",(O87*0.93),IF($E87=1,P87,O87)))
Thank you!
Is there any blank space before or after "kg"?
Try this,
=IF(ISBLANK(E87),"",IF(ISNUMBER(SEARCH("kg",D87)),(O87*0.93),IF($E87=1,P87,O87)))
Quang PT
Thank you - the 'isnumber' formula works.
I wonder why my original formula didn't work - I tried various combinations of " kg", "kg ", etc.!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks