If condition, copy cell value to another cell

[excel_excel_excel]

Hi all,

I have a drop down list with hours, days (A1)

If I choose "days" and type 168 in the next cell (B1)
it should come out like this below:

(A4)Days: (B4) =IF(A1="days"; B4=B4)
(A5)Hours: (B5)=IF(A1="days"; B4=B4*7)


So my problem is that excel needs B4 to be equal to B4 and then sets TRUE.
So if I set (B1) to 168, excel write FALSE, and If I manually type 168 in (B4) it goes TRUE.
But I want excel to copy 168 from (B2) and paste that into cell B4 and paste it into 1 (B2*7)

Sorry for my bad english and explanation, hope you understand.

Best regards

[FDibbins]

You cannot have a value AND a formula in a cell, you need to have 1 OR the other.

Also, formulas cannot "push" data/answers to another cell, they can only affect the cell they reside in.
I think you need to rethink how you want to do this?

[davsth]

I agree with Ford,

However if you are wanting B4 to be calculated from b1

IF(A1="days"; B4=B1, B1/7)