Excel formula

[Solved/Closed]
Report
-
 Nic -
hello,
hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c
thanks



1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Nick,

Place the following formula in B1 and drag down as far as needed:
=IF(A1>0,C1,"")

Best regards,
Trowa
Hi Trowa

Thanks a million for the prompt response! Still having an issue however - keeps telling me that there is an error in the formula?
Would the fact that there is an existing formula creating the value in C1 have any effect on the formula you propose?

Thanks
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486 > Nic
Hi Nic,

It doesn't matter if C1 contains a formula or not.
My guess is that you need to use ";" as separator instead of ",". This depends on your set language.
So try this:
=IF(A1>0;C1;"")

Best regards,
Trowa
>
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021

Sorted!! Fantastic - really appreciate your time and trouble

Thanks