IF AND FORMULA

  • Thread starter Thread starter Karen Smith
  • Start date Start date
K

Karen Smith

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Formula Help Needed 8
#N/A to blank 7
IF AND OR Formula Help 1
IF AND Formula Help Needed 7
IF Formula Help 4
Excel Vlookup and sumif function maybe a macro issue? 0
Formula Help 3
Excel Drag autofill only part of formula 3

Back
Top