How to add exceptions to functions using IF statements

Our take

In managing electrical components for your live A/V production, using IF statements can help customize your spreadsheet's functionality. To ensure that Columns D and E display "N/A" when the corresponding item in Column C is marked as such, you'll need to implement a conditional formula. This approach not only enhances clarity but also prevents errors like #VALUE or #SPILL. By carefully structuring your IF statements, you can streamline your data management process, making it more intuitive and user-friendly. Let's explore how to achieve this effectively.

Hello all.

I am trying to make a doc that features current draw for electrical components for a live A/V production I'm working on.

Currently, Column A is listing the Item names, Column B lists the quantity of each given item, Column C shows if the item features automatic voltage selection in a drop down menu (yes, no, N/A), Column D shows the per/unit current draw and Column E shows the total current draw for that item type.

I have Column E on that function:

=PRODUCT B3:B30*D3:D30

What I would like to do next is have Column D and E read N/A when Column C's N/A option is selected in the dropdown list.

I can't seem to find the correct IF statement without getting #VALUE or #SPILL errors in the column E

submitted by /u/TheAverageRoss
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#Excel alternatives#current draw#IF statement#electrical components#per/unit current draw#total current draw#A/V production#automatic voltage selection#N/A option#Item names#quantity#PRODUCT function#Excel#functions#drop down menu