Posted to microsoft.public.excel.worksheet.functions

SCP

external usenet poster

Posts: 5

Function Problem

Well, I'll start it to what I have so far, but I need one last improvement to
the formula to make it true, and I keep getting errors.

=IF(A14*G14<0.5,L14,(A14*G14))

I want it to multiply A x G
if the sum is less then .5 then to carry over the number from L
BUT if it's less than .5 but greater than L then to multiply it out

Thank You

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Sum function problem	Sue	New Users to Excel	9	June 19th 09 02:46 PM
Problem in If function	Junaid	Excel Worksheet Functions	7	January 27th 09 10:53 AM
function problem	chindo	Excel Worksheet Functions	6	November 10th 05 02:29 PM
Function problem	Sweeny	Excel Worksheet Functions	8	October 17th 05 12:13 AM
Problem with IF function	haitch2	Excel Worksheet Functions	3	October 10th 05 01:05 AM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us