#1   Report Post  
Junior Member
 
Posts: 1
Unhappy Excel "IF" Formula

I am trying to input a formula but keep getting an error message

I put this in and it works but its not what I want as it does not work for every senario =IF(I450,((I45*1%)+(D45+E45)*11%),(C19-476)*11%), but I really want another IF statement in there because if C19 is less than 476 I want it to return a zero

What I want the formula to do is to look at cell I45 and if its great than zero to multiply cell I45 by 1% and add to that result the product of D45+E45 multiplied by 11% If it is not greater than zero I want it to look at cell C19 and see if it is greater than 476 and if it is I want it to calculate the value of cell C19 minus 476 multiplied by 11% if cell C19 is less than 476 I want it to return zero. Can any one help me please
  #2   Report Post  
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by Babs Pay View Post
I am trying to input a formula but keep getting an error message

I put this in and it works but its not what I want as it does not work for every senario =IF(I450,((I45*1%)+(D45+E45)*11%),(C19-476)*11%), but I really want another IF statement in there because if C19 is less than 476 I want it to return a zero

What I want the formula to do is to look at cell I45 and if its great than zero to multiply cell I45 by 1% and add to that result the product of D45+E45 multiplied by 11% If it is not greater than zero I want it to look at cell C19 and see if it is greater than 476 and if it is I want it to calculate the value of cell C19 minus 476 multiplied by 11% if cell C19 is less than 476 I want it to return zero. Can any one help me please
--------------------------------------------------------------------------
Dear Babs Pay, Good Afternoon.

Try this formula:
=IF(I450,((I45*1%)+(D45+E45)*11%),IF(C19=476,(C1 9-476)*11%),0)

Tell me if it worked for you.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
  #3   Report Post  
Junior Member
 
Posts: 5
Default

If the numbers are formatted as times, you can simply subtract them. The results will be in decimal hours, e.g. half an hour is .5 and 45 minutes is .75 hours. If you have to deal with third shift hours, where a shift ends "before" it begins, add 24 hours.
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula for an "if" "then" scenario linking 3 worksheets John Excel Discussion (Misc queries) 2 February 23rd 10 06:56 PM
How do I write an excel formula with a text answer ("yes" or "no") pat Excel Discussion (Misc queries) 1 September 9th 08 03:41 PM
Formula Result is "V6", need Excel to use cell "V6", not the resul Erik Excel Worksheet Functions 3 September 5th 08 03:10 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 12:01 PM.

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"