Jump to content

Excel Help

GeorgeKellow
By GeorgeKellow
in Programs, Apps and Websites
 Share
Posted

Could you elaborate a bit on what you want to exactly do?

You can make an in a cell in column B if-statement that does something when there is data in the cell in column A next to it. But if that is really what you want, depends on what you are going to do.

"We're all in this together, might as well be friends" Tom, Toonami.

 

mini eLiXiVy: my open source 65% mechanical PCB, a build log, PCB anatomy and discussing open source licenses: https://linustechtips.com/topic/1366493-elixivy-a-65-mechanical-keyboard-build-log-pcb-anatomy-and-how-i-open-sourced-this-project/

 

mini_cardboard: a 4% keyboard build log and how keyboards work: https://linustechtips.com/topic/1328547-mini_cardboard-a-4-keyboard-build-log-and-how-keyboards-work/

Link to comment
https://linustechtips.com/topic/1128728-excel-help/#findComment-13085299
Share on other sites
Link to post
Share on other sites
Posted

Formulas that reference the cells as variables

 

But it really depends on what you want help with specifically

Community Standards || Tech News Posting Guidelines

---======================================================================---

CPU: R5 9600X || GPU: RX 9070 XT|| Memory: 32GB || Cooler: Peerless Assassin || PSU: RM850e|| Case: Lian Li A3

Link to comment
https://linustechtips.com/topic/1128728-excel-help/#findComment-13085306
Share on other sites
Link to post
Share on other sites
Posted

Ended up helping OP in a private message. This was the formula needed at the end: 

=IFERROR(IF(AND(SUMPRODUCT(--ISNUMBER(C11:G11)),NOT(SUMPRODUCT(--(C11:G11<>""))=0)),D11-C11-E11-F11-G11,""), "Data is not correct")

This checks if all the applicable cells can be counted up + have data in them.

If it gives an error, there's incorrect data. If it gives a number, that's a valid result. If it's blank, there is no data yet.

"We're all in this together, might as well be friends" Tom, Toonami.

 

mini eLiXiVy: my open source 65% mechanical PCB, a build log, PCB anatomy and discussing open source licenses: https://linustechtips.com/topic/1366493-elixivy-a-65-mechanical-keyboard-build-log-pcb-anatomy-and-how-i-open-sourced-this-project/

 

mini_cardboard: a 4% keyboard build log and how keyboards work: https://linustechtips.com/topic/1328547-mini_cardboard-a-4-keyboard-build-log-and-how-keyboards-work/

Link to comment
https://linustechtips.com/topic/1128728-excel-help/#findComment-13085631
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programs, Apps and Websites

×