# 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:

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