Thread
:
condition formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
condition formula
=IF(OR(B10="Boat",B10="Boat trailer"),C10+D10,"")
or if B10 will never contain any other Boat anything:
=IF(LEFT(B10,4)="Boat",C10+D10,"")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Kareinia" wrote in message
...
Could someone help me with this condition formula?
I need
If B10 equals, Boat or a Boat trailer, then add the hours of c10 into
d10
I would appreciate any help that you can give me.
Thanks so much!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann