Hi, I'm new to this forum, thank you for having me.
I am trying to put in a formula to say:
If A4=0 than A5 will be blank.
I've tried several different ways, but i can't seem to get it. Also, the cells already have a formula in it, will I have to use Conditional Formatting to add a rule?
Thank you again for the add and for your help!
Diora
Hi, welcome to the forum
maybe this, in A5...
=IF(A4="","",A4)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you Ford.
Since I already have a formula in there, do I add it as a rule under Conditional Formatting? I'm not sure how to add it on to formula that's already in there
This is what I have in there currently: =VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE)
You can try:
=IF(A4="","",VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE))
or
=IFERROR(VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE),"")
If I've helped U pls click on d *Add Reputation
If A4 is where you have that formula, then perhaps...
=IF(VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE)="","",VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE)
I tried both ways and it gives me an error.Am I able to post the spreadsheet?
Did you try the formula suggested by FDibbins?
If you can post your spreadsheet - please do
=IF(A4="","",IFERROR(VLOOKUP('Discount Store'!A4,'PRR570 7-20-15'!F7:AG10316,20,FALSE),""))
This in A5 should work correctly
Thank you everyone for your responses! I finally got this to work using the formula from FDibbins
I really appreciate your help FDibbins, bhenlee and Jdevil.
Have a wonderful day!
Diora
Im happy you got where you wanted to be, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks