Excel formula
Solved/Closed
Related:
- Excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Formula bar in excel missing - Guide
- Mark sheet grade formula in excel download - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Mar 24, 2015 at 12:25 PM
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
Place the following formula in B1 and drag down as far as needed:
=IF(A1>0,C1,"")
Best regards,
Trowa
Mar 25, 2015 at 02:04 AM
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
Mar 26, 2015 at 11:57 AM
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
Mar 27, 2015 at 03:05 AM
Thanks