If or sumif

seahawkD

New member
Joined
Aug 18, 2016
Messages
1
Reaction score
0
Points
0
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
 
This works. also you cannot include a $ sign like that. If its $300 dollars just put 300, and to show the value as a dollar symbol you can format the cell to currency.

=IF((A1*0.5)<8,(A1*0.5)*300,0)
 
Back
Top