@if formula
Solved/Closed
junebug65
Posts
2
Registration date
Wednesday October 7, 2015
Status
Member
Last seen
October 8, 2015
-
Oct 7, 2015 at 08:16 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Oct 8, 2015 at 05:02 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Oct 8, 2015 at 05:02 PM
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
Oct 7, 2015 at 08:53 PM
Oct 7, 2015 at 08:53 PM
Hi junebugs65,
Try this ...
=IF(B12="meals",F12/2,F12)
Paste this into any cell except B12 or F12 and it should work in the cell its pasted into.
I really appreciate thank you messages as a payment for solving issues :o)
Try this ...
=IF(B12="meals",F12/2,F12)
Paste this into any cell except B12 or F12 and it should work in the cell its pasted into.
I really appreciate thank you messages as a payment for solving issues :o)
Oct 7, 2015 at 09:52 PM
Thank you for getting back to me so quickly. It only works if it finds the exact word "meals'. Sometimes the cell can contain a different string like "staff meals' or "hotel and meals". How would I deal with that?
Oct 7, 2015 at 10:08 PM
Try this instead.
=IF(ISNUMBER(SEARCH("meals",B12)),F12/2,F12)
Hope this works for you. - let us know :^)
Oct 8, 2015 at 02:52 PM
YES! it works. I didn't quite know how to use the ISNUMBER function, tried to Google but couldn't find what I was looking for.
Thanks Brian. I'm sure you'll hear from me again.
Oct 8, 2015 at 05:02 PM