Forum Discussion
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 I need to use (UP or UN). So I was wondering if anyone could help me generate a formula that if I input tie in the upper box it returns the value of UP or if there is a value in the lower box it would return the value of UN and if there is no value, it would just remain empty.
Thank 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.
2 Replies
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!!!!
