|
|
#1
10-09-2018, 06:16 AM
|
|||
|
|||
Please Help with formula
Hi
Please see the following: [ATTACH]please see this 12711[/ATTACH] I have column A11 at £0.00 as the amount of column A8 equals the total amount of column A2. =IF(S4 = "", "",MIN(S4*Q4,F4)) I was looking to have a similar formula for column A10 as to when column A8 equals A2 I want A10 to read as 0. The current formula I have for A10 is =IF(N4 = "", "", NETWORKDAYS(L4, N4)) Can anyone help please? 
|
|
#3
10-09-2018, 08:31 AM
|
||||
|
||||
|
Perhaps post a small sample sheet with some data and expected results so we can work on it?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
|
Need help with IF formula
|
SMI | Word | 3 | 01-19-2016 06:33 AM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
| Formula Help | OTPM | Excel | 5 | 02-21-2013 08:03 AM |
Windows 8 
Office 2010 32bit
Linear Mode
