• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to change formula?

Eloise T

Active Member
I am trying to change the formula in Column L
from: =IF(D18<>"",D18*K18,"")
to: =IF(D18<>"",D18*K18,"-")

A former co-worker created this and is no longer reachable.
How do I change the formula?

Thank you in advance.
 

Attachments

  • Chandoo - invoice template.xlsx
    62.8 KB · Views: 10
Eloise T
1) 'just' go an activate one (the 1st) 'L-column'-cell
2) Clear it's 'Data Validation'
3) Edit that formula
4) Make that 'Data Validation' back
5) Pull down to get same formulas and data validations to other needed cells
 
Eloise T
1) 'just' go an activate one (the 1st) 'L-column'-cell
2) Clear it's 'Data Validation'
3) Edit that formula
4) Make that 'Data Validation' back
5) Pull down to get same formulas and data validations to other needed cells

Thank you....may have more questions later re: Data Validation.
 
Back
Top