#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,311
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"