using the if statment

[a2apple]

i apprechiate all the asistance.

i am trying create an if statment that looks at the day of the week and calculates 2 diffrent rates wether its a weekend which is a sunday or the rest for the week

in colume h7 i tryed to use the following formula
=if(B7=søn;[G8*B4];[G8*B3])

thank you for all your help

<tbody>
</tbody>

-- removed inline image ---

 

[FDibbins]

Hi, welcome to the board

Not sure what you posted, but it didn't come through too well lol

I think what you need is maybe this...
=G8*if($B7="søn";B4;B3)

This should work if you have actual weekday names in that cell. If you have real dates, formatted to just show the weekdays, look at using the WEEKDAY() function instead