Excel formula

Solved/Closed
Nic - Mar 24, 2015 at 09:08 AM
Nic - Mar 27, 2015 at 03:05 AM
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

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 24, 2015 at 12:25 PM
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552 > Nic
Mar 26, 2015 at 11:57 AM
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
Nic > TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022
Mar 27, 2015 at 03:05 AM
Sorted!! Fantastic - really appreciate your time and trouble

Thanks