Skip to main content

All Questions

0 votes
3 answers
13k views

How to do hex calculations across multiple cells in excel?

I'm working on a spread sheet and I have a table or grid of [256]x[256] that looks like this: B c D E F G IY 3 Address: [byte][byte][byte][byte] ... ...
Francis Cugler's user avatar
0 votes
1 answer
690 views

How do I calculate the ratio for a range of cells in excel?

I'm trying to calculate the number of females per 100 males in each state and display the result using cell arrays. If the data for any state is unavailable or producing an error, then empty cell ...
SB998's user avatar
  • 1
2 votes
7 answers
208k views

How do you add extra value to a cell that already has an existing number in it

I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
Ricky's user avatar
  • 21
0 votes
1 answer
9k views

Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...
Jeff's user avatar
  • 1