Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF AND FORMULA
I need a formula for the following:
If tab 'The Worker Be! cell B8 = SuperModule AND tab 'Stibo Calculations' cell S8 is not = to C. than add 85 + ('The Worker Be!' cell F8 * 225) * 'The Worker Be!' H8 * 'The Worker Be! X8 Can anyone help? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF AND FORMULA
Maybe something like this:
=IF(AND('The Worker Be'!B8="SuperModule",'Stibo Calculations'!S8<"C"),85+ ('The Worker Be'!F8*225) *('The Worker Be'!H8*'The Worker Be'!X8),"What if it's false?") HTH, Paul -- "Karen Smith" wrote in message ... I need a formula for the following: If tab 'The Worker Be! cell B8 = SuperModule AND tab 'Stibo Calculations' cell S8 is not = to C. than add 85 + ('The Worker Be!' cell F8 * 225) * 'The Worker Be!' H8 * 'The Worker Be! X8 Can anyone help? Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|