Hi,
I'm trying to write a formula with the following criteria: If travel is under 8 hours one way, 50% is billed at a rate of $300.
Assume round trip is 10 hours and I entered the total roundtrip amount in cell A1, then 50% of roundtrip = 5 hours (meets the criteria of being under 8 hours)
So I tried the following and I got the "contains an error" message =if(A1*0.5)<8,(((A1*0.5)*$300),0)
Please help! Thanks
I'm trying to write a formula with the following criteria: If travel is under 8 hours one way, 50% is billed at a rate of $300.
Assume round trip is 10 hours and I entered the total roundtrip amount in cell A1, then 50% of roundtrip = 5 hours (meets the criteria of being under 8 hours)
So I tried the following and I got the "contains an error" message =if(A1*0.5)<8,(((A1*0.5)*$300),0)
Please help! Thanks