Forum Discussion
Solved
IF, AND, OR Formula Help
2.5 2.5 Modifier Modifier HQ UP HQ UN Hello! So I have a spreadsheet I use for invoicing and depending on which box I input the hours in (2.5), determines what modifier...
The upper box value is in cell A1.
The lower box value is in cell B1.
Here’s a formula you can use:
=IF(A1<>"", "UP", IF(B1<>"", "UN", ""))
Hope this will help you.
The upper box value is in cell A1.
The lower box value is in cell B1.
Here’s a formula you can use:
=IF(A1<>"", "UP", IF(B1<>"", "UN", ""))
Hope this will help you.
Thank you! This worked perfectly for what I needed. Totally saves me time with invoicing now and eliminating any errors. Thank you again!!!!