LinkBack URL
About LinkBacks
Hi,
This is my first time, so please be gentle
I'm trying to input a formula, =SUM(F14)/($C$7)IF(>.05,*200,*100), but as you will see doesn't work, any help would be greatly appreciated, Thanks.
Hi,
This is my first time, so please be gentle
I'm trying to input a formula, =SUM(F14)/($C$7)IF(>.05,*200,*100), but as you will see doesn't work, any help would be greatly appreciated, Thanks.
Hi
0.5,*200,*100 =10000 Corect?
Then do you mean?
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try:
=F14/IF(C7>0.05,200,100)
or
=IF(F14/C7>0.05,F14/C7*200,F14/C7*100)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thanks Fotis for the prompt reply, I used the formula from RoberttMika and it works.
Hi Robert,
Sorry if you get this twice, I replied to your response but it hasn't appeared in the thread and I want you to know that the solution you supplied works a treat, many, many thanks for your help on this and the prompt response. Cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks