LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default IF with substraction

Firstly I don't believe that formula can return FALSE, whatever the inputs.
If you are convinced that it does, firstly copy the formula from your
formula bar and paste it here into the group; don't try to retype it.
Also tell us what is in each of the cells which are inputs to that formula,
in this case L8, E8, and M8.

Secondly you have unnecessary parentheses.
=IF(L8="50%",(E8-M8),IF(L8="0%",(H8-M8),0)) can be simplified to
=IF(L8="50%",E8-M8,IF(L8="0%",H8-M8,0))

Thirdly, are you sure that you want text strings for your percentage tests?
If you want numbers, ditch the quote marks.
=IF(L8=50%,E8-M8,IF(L8=0%,H8-M8,0))

Fourthly, the cells you refer to in your formula are not the cells you refer
to in your text, so sort out which row you are using.

Fifthly, I assume that when you talk about "substration" and "substraction"
you mean "subtraction"? If so, your method is correct, in that E8-M8 will
subtract the value in M8 from the value in E8.

Sixthly, you say no other options are available other than 50% or 0%. If
so, you may wish to flag an error if invalid inputs are given either in your
formula
=IF(L8=50%,E8-M8,IF(L8=0%,H8-M8,"Invalid input - only 50% or 0% permitted"))
or by the use of data validation in your L8 input cell.
--
David Biddulph

"Carolina" wrote in message
...
I have data in E7 and in H7. Depending on which data they want to go with I
need a formula to make a substration. If they select in L8 that they want
the
50% program then in another cell I need the result of E7-M7. If they
select
in L8 that they want the 0% program then in another cell I need the result
of
H7-M7. No other options available.

My attempt was the following but I got FALSE....I need the differences:
=IF(L8="50%",(E8-M8),IF(L8="0%",(H8-M8),0))

Can you help???

Thanks.
Carolina



 
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
Substraction formula Roger Excel Worksheet Functions 4 October 30th 08 01:11 PM
addition or substraction FGOMEZ Excel Discussion (Misc queries) 3 April 12th 06 09:41 PM
variable Addition and substraction Fran Gaffney Excel Worksheet Functions 0 April 11th 06 12:38 PM


All times are GMT +1. The time now is 02:31 PM.

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

About Us

"It's about Microsoft Excel"