Newbie question
'hello,
can someone explain in plain English what this formula is actually saying: =IF(C32="FOB",(B28:C28/'Board Pricing and conversion'!B19)-B28,(B28/'Board Pricing and conversion'!B20)-B28) I understand the C32="FOB", but the rest I don't. I know it is referencing another spreadsheet but don't know what it is looking at?? Thanks |
Newbie question
bassman
Double-click on the cell with the formula and you will see the syntax IF(logical_test, [value_if_true], [value_if_false]) You have a logical text for "FOB" on C32 of active sheet. If True then return the result of first argument which is the sum of cells B28:C28 on active sheet divided by cell B19 from worksheet Board Pricing and conversion -B28 on active sheet. If False, return the results from the second argument which is divide B28 by Board Pricing and conversion sheet B20 - B28 on active sheet. Note: This formula is an Array formula and must be entered using CTRL + SHIFT + ENTER Excel will place curly brackets around the entire formula{.......} Gord Dibben Excel MVP On 31 Oct 2005 14:05:57 -0800, "bassman" wrote: 'hello, can someone explain in plain English what this formula is actually saying: =IF(C32="FOB",(B28:C28/'Board Pricing and conversion'!B19)-B28,(B28/'Board Pricing and conversion'!B20)-B28) I understand the C32="FOB", but the rest I don't. I know it is referencing another spreadsheet but don't know what it is looking at?? Thanks |
All times are GMT +1. The time now is 12:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com