spreadsheet formulas

[Guest]

I havent been able to figure how to write "simple" formulas.... do i choose functions or do i just write the formula....
i need to subtract e4 and f4 from d4 then multiply by 40% for my total..

the other one i have is subtracting 2.95% + $.30 from d4

thanks so much for all the help

 

[Ken Wright]

Just write it as you would on paper

=(D4-E4-F4)*0.4 or
=(D4-(E4+F4))*0.4

=D4*(1-0.00295)-0.30 or if the brackets help clarify
=(D4*(1-0.00295))-0.30

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I havent been able to figure how to write "simple" formulas.... do i choose

functions or do i just write the formula....